Question: Need it in MYSQL and here are my databases Write a SELECT statement that returns all class data for classes that have too many students

Need it in MYSQL and here are my databases Write a

Need it in MYSQL and here are my databases

SELECT statement that returns all class data for classes that have too many students (i.e. the number of students exceeded the maximum students for the class). Use a Subquery (non-correlated) in a JOIN clause. Use only

Write a SELECT statement that returns all class data for classes that have too many students (i.e. the number of students exceeded the maximum students for the class). Use a Subquery (non-correlated) in a JOIN clause. Use only the subquery and the classes table. (Do not join to any other table) Return the following columns: class_id, name, code, maximum_students, number_of_students Hint: in the subquery use an aggregation and return the value along with the class_id, then use the subquery class_id in the ON clause. Testing the subquery before putting it into the outer query it may help. Example dass_id name 1 Computer Science 310 SQL Writing and Rhetoric code maximum_students number_of_students CS HU310 10 11 ENG 101 4 6 Deliverable 1: send your code & screenshot 111 112 SELECT * FROM students; Edit: Result Grid 1 Filter Rows: student_id first_name_last_name birth_date 1 Ross Wilcox 2001-02-25 2 Phoebe Rangel 2000-01-21 3 Hope Nouri 2002-03-22 4 Perry Levinson 1999-04-20 5 Hermann McDowel 2000-10-18 6 Lily Cierzan 2004-11-19 7 Endora Clayson 1998-09-17 8 Darwin Gowder 2001-11-16 9 Thatcher Siege 2005-08-01 10 Sage Valorant 2006-07-15 NULL NULL NULL NULL 94 SELECT * FROM classes Result Grid Filter Rows: | Edit: B Export/Import: dass_id name description code maximum_students Computer Science 310 SQL MySQL CS-HU310 10 2 Communications 113 comming COMM113 5 3 English 101 talking ENG 101 4 4 Martial Arts 030 MMA MA030 5 NULL NULL NULL w N NULL NULL 85. SELECT * FROM registered_students; 86 TNICENT TATA clocros Namo d w N 5 . Result Grid 1 Filter Rows: Edit: id dass_id student_id signup_timestamp 1 2 2021-02-07 13:46:46 2. 3 2021-02-07 13:46:46 3 1 4 2021-02-07 13:46:46 4 1 5 2021-02-07 13:46:46 1 7 2021-02-07 13:46:46 6 1 9 2021-02-07 13:46:46 7 1 10 2021-02-07 13:46:46 8 3 1 2021-02-07 13:46:53 9 3 2 2021-02-07 13:46:53 10 3 3 2021-02-07 13:46:53 11 3 7 2021-02-07 13:46:53 15 3 2 2021-02-07 13:47:00 16 3 4 2021-02-07 13:47:00 17 3 5 2021-02-07 13:47:00 18 3 7 2021-02-07 13:47:00 19 3 8 2021-02-07 13:47:00 20 3 9 2021-02-07 13:47:00 22 2 1 2021-02-07 13:47:13 23 2 1 2021-02-07 13:47:13

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!

Write a SELECT statement that returns all class data, and the number of students taking the class. Attached is the databases I am working with. SELECT FROM * registered_students; SELECT * FROM...

Complete all of the exercises below. There are five ( 5 ) exercises for each chapter from Week 2 ' s readings. All of these exercises use the my _ guitar _ shop database Download my _ guitar _ shop...

1. Write a SELECT statement to list course data sorted by course number. 2. Write a SELECT statement to list zipcodes and their cities in New York State sorted by zipcode. 3. Write a SELECT statement...

Write a SELECT statement that returns all class data for classes that have too many students. - Use a Correlated Subquery in a WHERE clause. (Do not use a JOIN statement.) - Hint: Compare to...

This is a assignment about MySQL. The Script file is: CREATE SCHEMA Tourista_DB; USE Tourista_DB; -- Table `Region` -- ----------------------------------------------------- SET AUTOCOMMIT = 0; SET...

**This is a MySQL assignment** The Script file is: CREATE SCHEMA Tourista_DB; USE Tourista_DB; -- Table `Region` -- ----------------------------------------------------- SET AUTOCOMMIT = 0; SET...

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

A. Write a PHP function 'bassAckwards' that will take a comma delimited string such as: Php,Cookies,Arrays,Mysql,LAMP And will return a string with the individual elements reversed, but in the same...

5. Create the following SQL queries using Select in the query window. Comment each step in the script. Each task must use a subquery. A. Plant the code below in your script commented as 5A-1. SELECT...

Why are standardization and quality control difficult to maintain throughout the service delivery process?

The number of items returned for each of the past 9 days was 13, 8, 36, 18, 6, 4, 39, 47, and 21. Test to see if the median number returned is significantly different from 40 and find the p-value (as...

content area top Part 1 (Related to Checkpoint 5.6) (Solving for i) Puck Van Houten, who has been married for 23 years, would like to buy their partner an expensive diamond ring with a platinum...

Alfonso Inc. acquired 100 percent of the voting shares of BelAire Company on January 1, 2020. In exchange, Alfonso paid $248,750 in cash and issued 100,000 shares of its own $1 par value common...

Question If a taxpayer is eligible for the maximum annual contribution to either a traditional or a Roth IRA, which should be chosen?

Question Can a Roth IRA invest in stock of the IRA owners business?

Question Can a participant in a qualified plan have the plan purchase life insurance on the life of another persona spouse or a business partner, for example?