Please don’t copy from the same site and No copy from any source. The work shoul
ID: 3703078 • Letter: P
Question
Please don’t copy from the same site and No copy from any source. The work should be your own words and answer. And please don’t answers be handwriting
Question Three Leaming Outcome(s) Use the tables below to answer the following questions: 1 Marks LO1: Analyse design and architect IT systems within small, medium and large corporate enterprises. Drivers FirstName Surname Ahmad Abdullah Rached Ali Address Drivede Abbas 822Madinah St. VR12300 126 Jeddah St 222 Dammam St. WQ33881 222 Dammam St TWN44556 AP22399 Ammar om Brown Price DriverID CarRegNo ABC 123 DEF 456 Nissan Sunny2012 10000 VR12300 GHI 789 Toyota Camry 2015 24000 AP22399 a) Write an SQL statement to list all Drivers' names along with their automobile Type Year BMW 323 2009 17000 VR12300 types, if any b)Write the output for the following SQL query SELECT DriverlD, Count (Type) AS Total FROM Automobiles WHERE (Automobiles.Price)>10000)) GROUP BY DriverIDExplanation / Answer
Answer:
1.
select d.DriverID,a.FirstName,a.SurName,d.TYPE
from Automobiles a
join Drivers d on d.DriverID = a.DriverID
order by d.DriverID
/*This query will list down all the Drivers Name with the type of automobiles*/
Output:
2.Output:
The above query returns the count of automobile types and Driver ID whose price is greater than 10000.
DriverID FirstName SurName Type VR12300 Ahmad Abbas BMW323 VR12300 Ahmad Abbas Nissan Sunny AP22399 Abdullah Rached Toyota Camry