SHOW TABLES : Para mostrar las tablas de la RDBMS

DROP TABLE IF EXISTS tabla_name : Para BORRAR la tabla de la BBDD.

INSERT: Allows you to create new data rows.

• INSERT INTO tabla_name (id, app_name, app_size, price, total_ratings, genre) VALUES (281656475, "PAC-MAN Premium", 100788224, 3.99, 4.5, "Games");

UPDATE: Allows you to update an existing data row.

• UPDATE rating SET price = 0 WHERE id = 281656475;

DELETE: Allows you to remove an existing data row.

• DELETE FROM rating WHERE id=281656475;

SELECT: Allows you to query data from a table

• SELECT * FROM rating; //we want all of the data in our table
• SELECT app_name, total_ratings, genre FROM rating;
• SELECT app_name, total_ratings, genre FROM rating WHERE genre = "Games";
• SELECT app_name, total_ratings, genre FROM rating WHERE genre = "Games" AND total_ratings > 4;

Aggregate functions allow you to turn multiple rows into a single value using some sort of calculation.

COUNT: counts rows in a specified table or view.

• SELECT genre, COUNT(*) FROM rating;

AVERAGE: calculates the average of a set of values.

• SELECT genre, AVG(price), AVG(total_ratings) FROM rating;

SQL Aggregate Functions

GROUP BY: Allows you to group rows where values of a column are the same.

• SELECT genre, COUNT(*) FROM rating GROUP BY genre;
• SELECT genre, AVG(price), AVG(total_ratings) FROM rating GROUP BY genre;

SQL GROUP BY