SQL

Question 1

Nom d’une commande en SQL

Answer 1

clause. s’écrit en majuscule ex: CREATE TABLE

Question 2

SQL
creates a new table.
adds a new row to a table.
queries data from a table.
edits a row in a table.
changes an existing table.
deletes rows from a table.

Answer 2

CREATE TABLE 
INSERT INTO 
SELECT 
UPDATE
ALTER TABLE 
DELETE FROM

Question 3

How to use clause WHERE name LIKE ‘exemple’ to search
names like ‘se[1 character]en’
names beginning with letter ‘a’
names containing ‘man’

Answer 3

WHERE name LIKE ‘se_en’
WHERE name LIKE ‘a%’
WHERE name LIKE ‘%man%’

Question 4

SQL : comment trouver tous les films dont l’année est comprise entre 1990 et 2000

Answer 4

SELECT * FROM movies

WHERE year BETWEEN 1990 AND 2000

Question 5

SQL : classer les films par ordre décroissant de classement IMDB, afficher le top 3

Answer 5

SELECT * FROM movies
ORDER BY imd_rating DESC
LIMIT 3;

Question 6

SQL : récupérer le nombre d’apps par groupe de prix

Answer 6

SELECT price, COUNT(*) FROM fake_apps

GROUP BY price;

Question 7

SQL : apps Calculate the average number of downloads at each price. In the code editor type

rounding the average number of downloads to two decimal

Answer 7

SELECT price, ROUND(AVG(downloads),2) FROM fake_apps

GROUP BY price;

Question 8

SQL : Comment désigne-t-on les différents types de clés

Answer 8

foreign keys and primary keys

Question 9

SQL : fonction pour transformer un timestamp en date

Answer 9

select date(timestamp)