3 of 3
Paper No: 4
EmployeelD
FirstName LastName Email
PhoneNumber
Position HireDate
1
3
Robert
Williams Jennifer Hernandez
[email protected]
555-1003
Mechanic 2000-03-25
2
8
[email protected]
555-1008 555-1012
Driver 2000-08-20
3
12
Susan Lewis
[email protected]
Mechanic 2000-12-10
4
16
Sarah
Wright
[email protected]
555-1016 555-1020
Driver 2001-04-30
5
20
Amanda Hill
[email protected]
Mechanic 2001-08-20
6
24
Natalie Carter
[email protected]
555-1024
Driver 2001-12-10 Mechanic 2002-04-30
7 28
Isabella Roberts
[email protected] 555-1028 555-1032
8
32
Charlotte Morris
[email protected]
Driver 2002-08-20
9 36
Evelyn Ward
[email protected]
555-1036
Mechanic 2002-12-10
10 40
Avery Price Samantha James
[email protected] [email protected] 555-1044
555-1040
Driver 2003-04-30
11 44
Mechanic 2003-08-20
12 48
Lucas Bennett
[email protected] [email protected]
555-1048
Driver 2003-12-10
13 52
Madison Harris
555-1052
Mechanic 2004-04-30
14 56
Chloe
Jordan
[email protected]
555-1056
15 60
Lily
Reed
[email protected]
555-1060
Driver 2004-08-20
Mechanic 2004-12-10
Picture 2.1
Question 3:
Write a query to select CarID, Maker, Model, Year, LicensePlate, Status, RentalLocationID,LocationName for all cars having a status of 'Available' that are currently in the rental location named 'Waterfront' or 'Central Park' as follows:
Zoom
+ 100%
Close
