Type the correct answer in the box. Spell the word correctly.
2 answers:
You might be interested in
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
<h3>Writting in SQL:</h3><em>select Customer.CID,CName,Age,Resid_City,BirthPlace,</em>
<em>Rentcost.Make,Cost,Rentals.Rtn,Date_Out,Pickup,Date_returned,Return_city</em>
<em>from Customer,Rentcost,Rentals where</em>
<em>Customer.CID=Rentals.CID and Rentcost.Make=Rentals.Make</em>
<em>order by Customer.CID, Rentcost.Make asc;</em>
<em />
<em>select Customer.CID,CName from Customer,Rentals where Customer.CID=Rentals.CID</em>
<em>and Pickup='Cary';</em>
<em />
<em>select distinct(CName),age from Customer,Rentals where Customer.CID=Rentals.CID</em>
<em>and Return_city='Erie' order by CName asc;</em>
<em />
<em>select Customer.CID,CName from Customer,Rentals where Customer.CID=Rentals.CID</em>
<em>and Return_city is null;</em>
<em />
<em>select CName from Customer,Rentals where Customer.CID=Rentals.CID</em>
<em>and Resid_City=Pickup;</em>
See more about SQL at brainly.com/question/13068613
#SPJ1
