QUESTION 11 Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is a valid query? A.
QUESTION 11 Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is a valid query? A. select w.company_name, count(employee_name) from works as w, company as c where w.company_name = c.company_name and salary> 200000 and count(employee_name) >= 100 group by w.company_name; B. select count(employee_name) >= 100 from works as w, company as c where w,company_name=c,company_name and salary > 200000 group by w.company_name; C. select w.company_name, count(employee_name) from works as w, company as c where w.company_name = c,company_name group by w.company_name having salary>200000 and count(employee_name) >= 100; D. select w.company_name, count(employee_name) from works as w, company as c where w.company_name = c.company_name and salary >200000 group by w.company_name having count(employee_name) >= 100; 5 points Saved
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To determine which SQL statement is valid lets break down the options based on typical SQL syntax ru...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started