SQL Queries and Table Operations for Video Game Database

Posted by on Jan 30, 2025 in Cinema and Television | 0 comments

Basic Aggregate Functions

Count (Cuenta)
SELECT COUNT(*) FROM juegos;
Min (Valor Minimo)
SELECT MIN(Precio) FROM Juegos;
Max (Valor Maximo)
SELECT MAX(Precio) FROM juegos;
Avg (Promedio)
SELECT AVG(Precio) FROM juegos;
Sum (Suma)
SELECT SUM(Precio) FROM Juegos WHERE Distribuidor = 'Blizzard';

Subgroups (Precio o Genero)

SELECT nom FROM juegos WHERE precio = (SELECT MIN(precio) FROM juegos);
SELECT genero, COUNT(*)

Table Creation and Modification

CREATE TABLE juegos (codjue int, Nom VARCHAR2(

Read More