Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 18 A database includes information about manufacture data of automobiles. Consider the following two relation schemas. AUTOS: Each model name (model) is the primary
QUESTION 18 A database includes information about manufacture data of automobiles. Consider the following two relation schemas. AUTOS: Each model name (model) is the primary key of Auros. Each maker (maker name) may produce one or more different models, indicated in the Autos table. For Example: ('Mustang', "Ford") . ('Focus', 'Ford) ('Dart', 'Dodge") ('Caravan', 'Dodge') PRODUCTION: The combined model name (model) and year (year) is the primary key for the PRODUCTION table. The model name (model) is a foreign key that references AUTOS.Model. The number of units manufactured (units_made) of each model is noted for each year (vear) in the PRODUCTION table. AUTOS Model Maker_name PRODUCTION Model Year Units made Write two different SQL queries: (a) Write a SQL query that displays the maker_name and number of different models produced by each maker. (b) Write a SQL query that displays the maker_name and total number of units manufactured for each maker whose overall total production is more than 10000 units (.e. exclude small auto manufacturers who have not yet produced more than 10000 vehicles in their entire history). Arial 3 (12pt) E-T- TT TT Paragraph v T T 351 S fx Mashups - 146 3. HTML CSS
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
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