Resources:Completed Week One Individual Assignment titled, "DreamHome Case Study"Completed Week Two Individual Assignment titled, "Object Oriented Data Model and SQL Query Definition"Appendix A, "User

SQL Queries

1. Listing the name of staff who work in a certain branch “Glasgow”

SELECT s.First_name,s. Last_name FROM Staff s, Branch b

WHERE b.city = ‘Glasgow’;

1. Showing everything from Branch object where the city is London

SELECT * FROM Branch

WHERE city=’London’;

1. Showing properties that are leased from January 2019

SELECT p.type, l.startDate FROM Properties p, Leases l

WHERE l.startDate = ‘2019-01’;

1. Showing properties owned by “Joe”

SELECT p.type, o.fname FROM Properties p, Owner o

WHERE o.fname = ‘Joe’;