Question: Which of the following isnota valid SQL statement? a. SELECT MIN (pubdate) FROM books GROUP BY category HAVING pubid = 4; b. SELECT MIN (pubdate)
Which of the following isnota valid SQL statement?
a. SELECT MIN (pubdate)
FROM books
GROUP BY category
HAVING pubid = 4;
b. SELECT MIN (pubdate)
FROM books
WHERE category = 'COOKING';
c. SELECT COUNT(*)
FROM orders
WHERE customer# = 1005;
d. SELECT MAX(COUNT (customer#))
FROM orders
GROUP BY customer#;
Step by Step Solution
3.51 Rating (161 Votes )
There are 3 Steps involved in it
a SELECT MIN p... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c121295cf_716636.pdf
180 KBs PDF File
1803_60b8c121295cf_716636.docx
120 KBs Word File
