SQL

Question 1

Selecione as colunas da tabela “actor” e filtre pelos nomes iniciados pela letra A

use o comando LIKE

Answer 1

select *
from actor
where first_name like ‘a%’
lllllllllllllllllllllllllllllllllll

Question 2

Selecione as colunas da tabela “actor” e filtre apenas os 10 primeiros resultados

use o comando LIMIT

Answer 2

select *
from actor
limit 10
llllllllllllllllllllllllllllllllllllllllllllllllllll

Question 3

Selecione as colunas da tabela “actor” e filtre os resultados de 6 a 15

use o comando LIMIT

Answer 3

select *
from actor
limit 5, 10
llllllllllllllllllllllllllllllllllllllllllllllllllll

Question 4

Selecione as colunas da tabela “actor” e filtre os resultados que contenham a letra A

use o comando REGEXP

Answer 4

select *
from actor
where first_name regexp ‘a’
lllllllllllllllllllllllllllllllll

Question 5

Selecione as colunas da tabela “actor” e filtre os resultados que comecem com a letra A

use o comando REGEXP

Answer 5

select *
from actor
where first_name regexp ‘^a’
lllllllllllllllllllllllllllllllll

Question 6

Selecione as colunas da tabela “actor” e filtre os resultados que comecem com a letra A e com a letra C

use o comando REGEXP

Answer 6

select *
from actor
where first_name regexp ‘^a|^c’
lllllllllllllllllllllllllllllllll

Question 7

Selecione as colunas da tabela “actor” e filtre os resultados que comecem com as letras CA, DA e SA

use o comando REGEXP

Answer 7

select *
from actor
where first_name regexp ‘^[cds]a’
llllllllllllllllllllllllllll

Question 8

Selecione as colunas da tabela “address” e filtre os resultados cujo distrito seja California, Buenos Aires ou England

use o comando IN

Answer 8

select *
from address
where district in (‘California’, ‘Buenos Aires’, ‘England’)

Question 9

Selecione as colunas
“customer_id”, “first_name” e “last_name” da tabela “customer”
e una com as colunas
“rental_id” e “amount” da tabela “payment”

use o comando JOIN
use ALIAS para nomear as tabelas CUSTOMER e PAYMENT

Answer 9

select
customer.customer_id,
customer.first_name,
customer.last_name,
payment.rental_id,
payment.amount
from customer
join payment on customer.customer_id = payment.payment_id

Question 10

Insira um novo idioma na tabela “language”

Answer 10

insert into language
values (
default,
‘Portuguese’,
‘2006-02-15 05:02:20’
)

Question 11

Insira uma nova cidade na tabela “city”

Answer 11

insert into city
values (
default,
‘Três Corações’,
15,
‘2023-09-26 16:45:00’
)

Question 12

Crie uma cópia de uma tabela

Answer 12

create table payment_backup as
select * from payment
lllllllllllllllllllllllllllll

Question 13

Atualize o valor da coluna “amount” da tabela PAYMENT, cujo payment_id é igual a 1

Answer 13

update payment
set amount = 8.99
where payment_id = 1
llllllllllllllllllllllll

Question 14

Delete um registro de alguma tabela

Answer 14

DELETE FROM payment
WHERE payment_id = 16049
lllllllllllllllllllllllllllllllllllll

Question 15

Liste o menor valor, o maior valor, a média, soma e o número de vendas do funcionário 1

Answer 15

SELECT
MAX(amount) as “Valor máximo”,
MIN(amount) as “Valor mínimo”,
AVG(amount) as “Média”
SUM(amount) as “Vendas Totais”
COUNT(amount) as “Número de vendas”
FROM payment
WHERE staff_id = 1