Question

home / study / engineering / computer science / computer science questions and answers / customer customerid,lastname,firstname, address,city,state,zip,email houses houseid, price ... Your question has been answered Let us know if you got a helpful answer. Rate this answer Question: Customer Customerid,lastname,firstname, address,city,state,zip,email Houses Houseid, price range,... Customer Customerid,lastname,firstname, address,city,state,zip,email Houses Houseid, price range, regionid, housename, bedroom no., pool, address, city,state,zip Reservations reservationid, customerid, date reservation, discount, start date, end date House amenities houseid, amenities id Price Range- houseid,price,start date, end date Create a query using the IN keyword with a subquery. State the purpose of the query; show the query and the output.

Answer 1

Query) Query to find customers who have done a reservation starting from 1st April, 2019.

SELECT lastname, firstname from Customer WHERE Customerid IN (SELECT customerid FROM Reservation WHERE start > '2019-04-01');