Select the query to display all the columns from the student table whose score is in the range of 80 to 90.
Question
Select the query to display all the columns from the student table whose score is in the range of 80 to 90.
Solution 1
The SQL query to display all the columns from the student table whose score is in the range of 80 to 90 would be:
SELECT *
FROM student
WHERE score BETWEEN 80 AND 90;
Here's a step-by-step breakdown of the query:
-
SELECT *: This statement is used to select all the columns from the table. -
FROM student: This statement specifies the table from which we want to retrieve data, in this case, the 'student' table. -
WHERE score BETWEEN 80 AND 90: This is a condition to filter the records. It selects the records where the 'score' is between 80 and 90.
Solution 2
The SQL query to display all the columns from the student table whose score is in the range of 80 to 90 would be:
SELECT *
FROM student
WHERE score BETWEEN 80 AND 90;
Here's a step-by-step breakdown of the query:
-
SELECT *: This statement is used to select data from a database. The asterisk (*) is used to select all columns. -
FROM student: This statement specifies the table from which you want to fetch the data. In this case, it's the "student" table. -
WHERE score BETWEEN 80 AND 90: This is a condition to filter the records. It selects only the students whose score is between 80 and 90.
Similar Questions
You have created a query to list information from the students table:SELECT student_id, grade_point_average FROM students ORDER BY grade_point_averageA partial result is shown below:Student_idgrade_point_average12344.015473.918763.929343.897253.883203.420433.339483.0You want the results to look like this:Student_idgrade_point_average12344.015473.918763.929343.897253.8You begin revising your query:SELECT student_id, grade_point_average FROM students ORDER BY grade_point_average ______ 5What should you type in the blank space? (Please type your answer all in upper case. Example: SELECT)
Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name. Query: Display all the student name, course name and also age of the students, whose age is between 23 to 27 and course having 'BCA'. Find out the students whose age is maximum.
You have a database that tracks students in the students table by student_id. The names of the semesters are in a semesters table where the primary key is semester_id. Each semester, students are assigned a grade_point_average which is stored in the grades table. The grades table lists the student_id and the semester_id in addition to the grade_point_average.You need to create a query that finds all the semesters where the student had a grade point average that was less than their average grade point average. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)
he marks obtained by 40 students out of 50 in a class are given below in the table.Marks (in $)4236304550Number of Students7101382Find the mode of the above data.
Given 3 tables, students(id, name) , courses(id, name) , grades(id, course_id, student_id, grade), find the name of the most popular course (the one with the most enrolled students and students should be passing, i.e. achieving a grade of at least 50) and if there is a tie, get the course name that's lexicographically smaller. Your query should output a table with the following columns (name)
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.