Question: Consider the following SQL query: SELECT projectID, COUNT ( * * ) FROM WorksIn GROUP BY projectName; Which section of the query is illegal? a

Consider the following SQL query:
SELECT projectID, COUNT (**)
FROM WorksIn
GROUP BY projectName;
Which section of the query is illegal?
a. projectName in the GROUP BY clause
b. COUNT(**) in the SELECT clause
c. projectID in the SELECT clause
 Consider the following SQL query: SELECT projectID, COUNT (**) FROM WorksIn

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!