From the following table (File –> Clients.sql)
-- Create the Clients table
CREATE TABLE Clients (
ID_Client INT PRIMARY KEY,
Name VARCHAR(50),
City VARCHAR(50),
Age INT
);
-- Insert sample data
INSERT INTO Clients (ID_Client, Name, City, Age) VALUES
(1, 'Anna Puig', 'Barcelona', 28),
(2, 'Marc Solé', 'Girona', 35),
(3, 'Laia Rius', 'Tarragona', 22),
(4, 'Jordi Pons', 'Lleida', 30),
(5, 'Carla Vives', 'Barcelona', 40);
Select all clients from Barcelona.
Show only the names and ages of the clients.
Add a new client: “Paula Serra” from Girona, aged 27.
Which clients are older than 30?
