English
CBSECommerce (English Medium) Class 12
Question Papers2580
Textbook Solutions20345
MCQ Online Mock Tests42
Important Solutions22654
Concept Notes & Videos608
Time Tables24
Syllabus

______ clause is used with a SELECT statement to display data in a sorted form with respect to a specified column. - Computer Science (Python)

Advertisements
Advertisements

Question

______ clause is used with a SELECT statement to display data in a sorted form with respect to a specified column.

Options

  • WHERE
  • ORDER BY
  • HAVING
  • DISTINCT
MCQ
Fill in the Blanks
Advertisements

Solution

ORDER BY clause is used with a SELECT statement to display data in a sorted form with respect to a specified column.

Explanation:

The order by clause can be used to arrange a table's data in a certain order. 

shaalaa.com
SQL for Data Query
  Is there an error in this question or solution?
Q 12
2022-2023 (March) Set 4

APPEARS IN

2022-2023 (March) Set 4 (with solutions)
Q 12 | 1 mark

RELATED QUESTIONS

Which of the following is not a comparison query?


Consider the following SQL.

SELECT ______ FROM Employee WHERE Dept= 'Printing';

Which of the following should be used to find the mean of the salary?


Which of the following is not true for SQL?


Which of the following is not a constraint?


Which constraint ensures that a column cannot have NULL values where NULL means missing/unknown/not applicable value?


Which constraint ensures that all the values in a column are distinct/unique?


______ operator defines the range of values in which the common value must fall into to make condition true.


Write the output produced by the following SQL statement:

SELECT POW(2, 3);


Consider the following MOVIE table and write the SQL query based on it.

MovieID MovieName Category ReleaseDate ProductionCost BusinessCost
001 Hindi_Movie Musical 2018-04-23 124500 130000
002 Tamil_Movie Action 2016-05-17 112000 118000
003 English_Movie Horror 2017-08-06 245000 360000
004 Bengali_Movie Adventure 2017-01-04 72000 100000
005 Telugu_Movie Action - 100000 -
006 Punjabi_Movie Comedy - 30500 -
  1. Display all the information from the Movie table.
  2. List business is done by the movies showing only MovieID, MovieName, and Total_Earning. Total_ Earning to be calculated as the sum of ProductionCost and BusinessCost.
  3. List the different categories of movies.
  4. Find the net profit of each movie showing its MovieID, MovieName, and NetProfit. Net Profit is to be calculated as the difference between Business Cost and Production Cost.
  5. List MovieID, MovieName, and Cost for all movies with ProductionCost greater than 10,000 and less than 1,00,000.
  6. List details of all movies which fall in the category of comedy or action.
  7. List details of all movies which have not been released yet.

Consider the following MOVIE table and write the SQL query based on it.

MovieID MovieName Category ReleaseDate ProductionCost BusinessCost
001 Hindi_Movie Musical 2018-04-23 124500 130000
002 Tamil_Movie Action 2016-05-17 112000 118000
003 English_Movie Horror 2017-08-06 245000 360000
004 Bengali_Movie Adventure 2017-01-04 72000 100000
005 Telugu_Movie Action - 100000 -
006 Punjabi_Movie Comedy - 30500 -

List the different categories of movies.


Consider the following MOVIE table and write the SQL query based on it.

MovieID MovieName Category ReleaseDate ProductionCost BusinessCost
001 Hindi_Movie Musical 2018-04-23 124500 130000
002 Tamil_Movie Action 2016-05-17 112000 118000
003 English_Movie Horror 2017-08-06 245000 360000
004 Bengali_Movie Adventure 2017-01-04 72000 100000
005 Telugu_Movie Action - 100000 -
006 Punjabi_Movie Comedy - 30500 -

Find the net profit of each movie showing its MovieID, MovieName, and NetProfit. Net Profit is to be calculated as the difference between Business Cost and Production Cost.


Consider the following MOVIE table and write the SQL query based on it.

MovieID MovieName Category ReleaseDate ProductionCost BusinessCost
001 Hindi_Movie Musical 2018-04-23 124500 130000
002 Tamil_Movie Action 2016-05-17 112000 118000
003 English_Movie Horror 2017-08-06 245000 360000
004 Bengali_Movie Adventure 2017-01-04 72000 100000
005 Telugu_Movie Action - 100000 -
006 Punjabi_Movie Comedy - 30500 -

List details of all movies which fall in the category of comedy or action.


Consider the following MOVIE table and write the SQL query based on it.

MovieID MovieName Category ReleaseDate ProductionCost BusinessCost
001 Hindi_Movie Musical 2018-04-23 124500 130000
002 Tamil_Movie Action 2016-05-17 112000 118000
003 English_Movie Horror 2017-08-06 245000 360000
004 Bengali_Movie Adventure 2017-01-04 72000 100000
005 Telugu_Movie Action - 100000 -
006 Punjabi_Movie Comedy - 30500 -

List details of all movies which have not been released yet.


Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

Display the MatchID of all those matches where FirstTeam has scored less than 70 but SecondTeam has scored more than 70.


Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

Display the MatchID and date of matches played by Team 1 and won by it.


The SELECT statement when combined with the ______ clause returns records without repetition.


Consider the following tables – Bank_Account and Branch:

Table: Bank_Account

ACode Name Type
A01 Amrita Savings
A02 Parthodas Current
A03 Miraben Current

Table: Branch

ACode City
A01 Delhi
A02 Mumbai
A01 Nagpur

What will be the output of the following statement?

SELECT * FROM Bank_Account NATURAL JOIN Branch;


The code given below reads the following records from the table employee and displays only those records that have employees coming from the city 'Delhi':

E_code - String
E_name - String
Sal - Integer
City - String

Note the following to establish connectivity between Python and MySQL:

  • Username is root
  • Password is root
  • The table exists in a MySQL database named emp.
  • The details (E_code,E_name,Sal,City) are the attributes of the table.

Write the following statements to complete the code:

Statement 1 - to import the desired library.

Statement 2 - to execute the query that fetches records of the employees/coming from the city ‘Delhi’.

Statement 3 - to read the complete data of the query (rows whose city is Delhi) into the object named details, from the table employee in the database.

import ____________ as mysql  #Statement 1
def display():
   mydb=mysql.connect(host="localhost",user="root"
   passwd="root", database=" emp")
   mycursor=mydb.cursor()
   ____________ #Statement 2
   details = ____________ # Statement 3
   for i in details:
       print (i)

Consider the tables PRODUCT and BRAND given below:

Table: PRODUCT
PCode PName UPrice Rating BID
P01 Shampoo 120 6 M03
P02 Toothpaste 54 8 M02
P03 Soap 25 7 M03
P04 Toothpaste 65 4 M04
P05 Soap 38 5 M05
P06 Shampoo 245 6 M05
Table: BRAND
BID BName
M02 Dant Kanti
M03 Medimix
M04 Pepsodent
M05 Dove

Write SQL queries for the following:

  1. Display product name and brand name from the tables PRODUCT and BRAND.
  2. Display the structure of the table PRODUCT.
  3. Display the average rating of Medimix and Dove brands.
  4. Display the name, price, and rating of products in descending order of rating.

Share
Notifications

Englishहिंदीमराठी
Login
Create free account


      Forgot password?
Course
Use app×