PolyannaMeira

GIT

Estados

• Modificado (modified);
• Preparado (staged/index)
• Consolidado (comitted);

Ajuda

PolyannaMeira

-- 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%';

PolyannaMeira

USE linkedin;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(100),
    username VARCHAR(100) UNIQUE,
    password VARCHAR(100)
);

PolyannaMeira

USE Formule1;

CREATE TABLE team (
    id INTEGER  PRIMARY KEY,
    name VARCHAR(100) UNIQUE ,
    country VARCHAR(100),
);

CREATE TABLE car (
    id INTEGER PRIMARY KEY,