Evaluate The Following Statement Select Count Book Id Auth Id Publisher Id From Books Where Discount Y Group By P 1 (52.36 KiB) Viewed 32 times
Evaluate The Following Statement Select Count Book Id Auth Id Publisher Id From Books Where Discount Y Group By P 2 (26.73 KiB) Viewed 32 times
Evaluate the following statement SELECT COUNT(book_id), auth_id, publisher_id FROM books WHERE discount = 'Y' GROUP BY publisher_id HAVING COUNT (book_id) > 10 ORDER BY publisher_id Why does the statement above throw a syntax error? a. The HAVING clause cannot specify an aggregate function b. ORDER BY clause must be placed before GROUP BY clause c. A single query cannot contain a WHERE clause and a HAVING clause d. auth_id must be included in GROUP BY clause
SELECT student_id, subject_id FROM lecturer, instructs WHERE lecturer_ID = instructs_ID; Which of the following query will produce a similar result to the query above? a. Select student_id, subject_id from lecturer inner join instructs on lecturer_ID = instructs_ID; b. Select student_id, subject_id from lecturer right join instructs; c. Select student_id, subject_id from instructs inner join lecturer where lecturer_ID = instructs_ID; d. Select student_id, subject_id from lecturer full join instructs;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!