Q81. Consider the following column of table "student"
Name
Amit
Sumit
Naina
Null
Write the output of the following query.
Select Count(*) from student;
Q82. Consider the following column of table "Teacher"
Name
Amit
Sumit
Naina
Null
Write the output of the following query.
Select Count(Name) from Teacher;
Q83. Consider the following column of table "sports".
Category
1
2
3
2
1
4
1
Write the query for the following
Display the total number of records from table "sports" having category 1
Q84. Consider the following column of table "sports".
Category
1
2
3
2
1
4
1
Write the query for the following
Display the total number of different types of category from table "sports".
Q85. _________________ Clause in SQL is used to specify conditions on the rows with Group By clause.
Q86. Which clause fetch a group of rows on the basis of common values in a column?
Q87. Consider the table given below and answer the following questions
Write the query for the following:
Display the number of Cars purchased by each Customer from SALE table.
Q88. Refer to the table given in Q87, Write the query to display the Customer Id and number of cars purchased if the customer purchased more than 1 car from SALE table.
Q89. Refer to the table given in Q87, Write the query to display the number of people in each category of payment mode from the table SALE.
Q90. Refer to the table given in Q87, Write the query to display the PaymentMode and number of payments made using that mode more than once.