Question

Write and execute a query that will determine the average number of days that automobiles are rented. Show your result broken out by makes. Do not include an automobile if it has not yet been returned.

Answer 1

Using the knowledge in computational language in SQL it is possible to write a code that query that will determine the average number of days that automobiles are rented

Writting in SQL:

select Customer.CID,CName,Age,Resid_City,BirthPlace,

Rentcost.Make,Cost,Rentals.Rtn,Date_Out,Pickup,Date_returned,Return_city

from Customer,Rentcost,Rentals where

Customer.CID=Rentals.CID and Rentcost.Make=Rentals.Make

order by Customer.CID, Rentcost.Make asc;

select Customer.CID,CName from Customer,Rentals where Customer.CID=Rentals.CID

and Pickup='Cary';

select distinct(CName),age from Customer,Rentals where Customer.CID=Rentals.CID

and Return_city='Erie' order by CName asc;

select Customer.CID,CName from Customer,Rentals where Customer.CID=Rentals.CID

and Return_city is null;

select CName from Customer,Rentals where Customer.CID=Rentals.CID

and Resid_City=Pickup;

See more about SQL at brainly.com/question/13068613

#SPJ1