Question

1 - Which of the following allows you to create subtotals in the output from a SELECT statement?

Group of answer choices

_ SUBTOTAL

_ ORDER BY

_ HAVING

_ GROUP BY

2 - A query includes grouping done using the AVG, SUM, COUNT, MIN, or MAX function. Which SQL keyword is used to select rows after this grouping has been done?

Group of answer choices

_ WHERE

_ DISTINCT

_ HAVING

_ LIKE

3 - Which of the following is the correct SQL clause to restrict the results of a SELECT query to only rows that have a value in the range of 10 to 50 in the Hours column?

Group of answer choices

_ WHERE Hours BETWEEN 10 AND 50

_ WHERE Hours IN [10, 50]

_ WHERE Hours = 10 and Hours = 50

_ WHERE Hours = MIN(10) and MAX(50)

Answer 1

се стосо брод 1 л Synted, ми, WHER Select column _name(s) EROM ta Column_name BETWEEN valued AND volue ai Kolumn values Which of the be following. It selects Column of Table where perticular m values lies blo value a and values. the following is the correct sol to restrict cleuse the results of a SELECT query to only news, that have a value in the range of lo to so o o Aps - WHERE Hours BETWEEN 10 AND 50. 0 which of the following allows you to create sublotels in the output from a select statement Aus! GROUP BY Let - Select COUNT (Student Id), subject from student croup By subject; LA query includes grouping done using the AVG A query UNT, MIN or MAX function which soll resword is used to select rews after grouping her SUM, COUNT, MIN OF MAX done been LAVING Add having Marks 750; in abone query