Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
List the car types with mark Peugeot Show the count of the rents by customers PowerPoint Presentation
Download Presentation
List the car types with mark Peugeot Show the count of the rents by customers

List the car types with mark Peugeot Show the count of the rents by customers

124 Views Download Presentation
Download Presentation

List the car types with mark Peugeot Show the count of the rents by customers

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Exercises 1 • List the car types with mark Peugeot • Show the count of the rents by customers • How many cars have the rate more than 45 €? • Show the last names of the customers whose last name begins with C sorted in descending order • Add a customer John Wayne to the customer-table • Add the address “2 Main St.” to John Wayne • Add the postal code “23456” to John Wayne • Show the customer ids, last names, first names and register numbers of the rents where the customer id is less than 4 • List the cars whose rates are lower than the average rate. • Add a new rent to the rent-table, where customer id is 4, car is ‘BSA-224’ and the rent day is the 11 April, 2005

  2. Exercises 2 • Show the lowest and highest rent dates of the rents by car • Show the register numbers, marks, models and rent dates of the rents where the register number begins with B and the return date is missing • List all rents • List the register numbers, marks and models of the cars where rates are at least 30 € and no more than 50 € • Add a new car with reg_no ‘EEE-666’ and model id 2 to the car-table • Add the rate 60 to car ‘EEE-666’ • How many rents are there in 2005? • Show the cust_ids and the corresponding counts of rents • List those customers’ last names in which the last name begins with A and ends with s • List the cust_ids of the rent table where the count of rents is more than 2