Scribd
Upload
19 views2 pages

Tutorial

Uploaded by

Yoon Yati Cho
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
19 views2 pages

Tutorial

Uploaded by

Yoon Yati Cho
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SELECT staff_no, forename, surname, salary

FROM Staff;

Where salary>20000

Algebra

(Staff where Salary>15000([staff_number, forename,surname,salary]

2.

SQL

SELECT staff_number,forename,surname,salary

From Staff;

Algebra

Staff[Staff_number,forename,surname,salary]

3.

SQL

SELECT staff_number,forename,surname,salary

FROM Staff

WHERE salary<20000

Algebra

(Staff where salary<20000)[staff_number,forename,surname,salary]

4.

SQL

SELECT location AS town

FROM Property;

Algebra

(Branch[town] U Property[location]
7. SQL

SELECT

[Link],

[Link],

[Link]

FROM

Client

INNER JOIN

Viewing

ON

Client.client_id = Viewing.client_id;

SELECT [Link],Client,surname,Viewing,comments

FROM Client,Viewing,Property

WHERE Client.client_id = Viewing.client_id

AND Viewing.property_id = Property.propery_id;

Algebra

(Client[Client.client_id = Viewing.client_id]^

You might also like