SQL is composed by 2 main parts

• DDL: Data Definition Language (for table definition, constraints,…)
• DML: Data Manipulation Language (to write query)

SELECT $\leftarrow$ Target List $\leftarrow \pi$

FROM

WHERE $\leftarrow \sigma$

1. SELECT

To visualize the content of the table

SELECT * FROM PROJECT

Extract the Project Names and Locations

SELECT
	Pname AS Project_Name,
	Plocation AS Project_Location
FROM PROJECT

Extract monthly salary

SELECT
	Lname,
	Fname,
	Salary/12 as monthly_salary
FROM EMPLOYEE

2. WHERE

Name and Surname of Female Employees (and salary greater than 40000)