(a) Write a SQL query to retrieve the van numbers, the makes and models and the...

  

Transcribed Image Text:

(a) Write a SQL query to retrieve the van numbers, the makes and models and the mileages for those vans that are 'Mercedes' vans and that have more than 100000 miles on their counters. (b) Write a SQL query that lists all the details of the 'FORD' vans that are owned by the 'IKEA' company or the 'Argos' company. (c) Explain the following Data Control Language (DCL) statement. GRANT SELECT, UPDATE (company TelNo) ON Company TO Personnel; (a) Write a SQL query to retrieve the van numbers, the makes and models and the mileages for those vans that are 'Mercedes' vans and that have more than 100000 miles on their counters. (b) Write a SQL query that lists all the details of the 'FORD' vans that are owned by the 'IKEA' company or the 'Argos' company. (c) Explain the following Data Control Language (DCL) statement. GRANT SELECT, UPDATE (company TelNo) ON Company TO Personnel;

Answer rating: 100% (QA)

a Write a SQL query to retrieve the van numbers the makes and models and the mileages for tho... View the full answer