Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Understand the third phase of the writing process: revision.

Answered: 1 week ago

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago