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

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