GO
SELECT * FROM Customer
GO
SELECT * FROM Vehicle WHERE CustomerID = 'ECO062515'
GO
SELECT * FROM Vehicle WHERE RentalPricePerDay IS NOT NULL
GO
SELECT * FROM Staff
GO
SELECT * FROM Sale
GO
SELECT * FROM Booking
GO
SELECT * FROM Branch
GO
SELECT * FROM Part
GO
SELECT Branch FROM Staff WHERE StaffID = 'S000021'
GO


'Eco Bikes Swansea Town'
'Eco Bikes Cardiff Town'
'Eco Bikes Swansea Warehouse'
'Eco Bikes Cardiff Warehouse'

SELECT * FROM Manufacturer 
SELECT * FROM Branch 
SELECT * FROM VehicleType 
SELECT * FROM Part
SELECT * FROM Vehicle WHERE OwnedByUS = 'True'
SELECT * FROM Customer WHERE Branch = 

SELECT * FROM Staff WHERE Branch = 
SELECT * FROM Sale WHERE Branch = 
SELECT * FROM Booking WHERE Branch = 
SELECT * FROM Requests WHERE Branch = 
SELECT * FROM Trading WHERE Branch = 
SELECT * FROM TradingVehicle WHERE TradeID = (SELECT TradeID FROM Trading WHERE Branch = )
SELECT * FROM TradingPart WHERE TradeID = (SELECT TradeID FROM Trading WHERE Branch = )
SELECT * FROM MaintenanceBooking WHERE Branch = 
SELECT * FROM MaintenanceRequests WHERE BookingID = (SELECT BookingID FROM MaintenanceBooking WHERE Branch = )

SELECT * FROM Vehicle WHERE CustomerID = (SELECT * FROM Customer WHERE Branch =  )