Smita81

formula1.sql

CREATE TABLE Driver (
    DriverID INT PRIMARY KEY,
    Name VARCHAR(100) NOT NULL,
    Nationality VARCHAR(50),
    DateOfBirth DATE
);
 
CREATE TABLE Team (

Smita81

-- 1. What are the names of countries with population greater than 8 million?--
SELECT Name
FROM country 
WHERE Population > 8000000;

-- 2. What are the names of countries that have “land” in their names? --
SELECT Name
FROM country
WHERE Name LIKE '%land%';