@Videonerd03

-- Yes their is an order -- SELECT (Required) -- FROM (Required) -- JOIN (Combines 2 tables based on a column ) -- WHERE (Filtering Rows) -- GROUP BY (Grouping Values by unique categories - or - groups -) -- HAVING (Filtering the categories from the GROUP BY - ONLY used with GROUP BY) -- ORDER BY (Sort values in Ascending -ASC - or descending - DESC - order) -- LIMIT (Return the Top N Values) -- top 5 limit or top 10 limit

-- Self Join CREATE TABLE Employee( ID INT PRIMARY KEY, Name VARCHAR(40), ManagerID INT ); INSERT INTO Employee(ID, Name, ManagerID)VALUES (1, 'Alice Johnson', NULL),

-- An INNER JOIN returns only the rows where there is a match between the two tables based on the join condition CREATE TABLE Guest ( GuestCardNumber VARCHAR(20) PRIMARY KEY, Name VARCHAR(20), CheckInTime DATETIME, VIPStatus INT CHECK (VIPStatus IN (0,1)) );

CREATE TABLE Employee ( EmployeeCardNumber CHAR(10) PRIMARY KEY, -- Fixed length Name VARCHAR(100), Role VARCHAR(50), AccessToThirdFloor INT CHECK (AccessToThirdFloor IN (0,1)), YearsWithShip INT, Salary DECIMAL(10,2) ); CREATE TABLE LoungeLog (

CREATE TABLE Guest( GuestCardNumber VARCHAR(20) PRIMARY KEY, Name VARCHAR(10), CheckInTime DATETIME, VIPStatus INT CHECK (VIPStatus IN (0,1)) -- Integer 1 = VIP 0 = Regular ); INSERT INTO Guest (GuestCardNumber, Name, CheckInTime, VIPStatus) VALUES ('GC001', 'Alice', '2025-10-01 14:30:00', 1),

CREATE TABLE Hospitals ( HospitalID INT CHECK (HospitalID> 0), -- Positive Integer HospitalName VARCHAR(100), EstablishedDate DATE, AnnualBudget DECIMAL(8,2) CHECK (AnnualBudget>0), -- Positive decimal up to 999999.99(8), two decimal places Type CHAR(2), -- fixed length Director VARCHAR(50) ); CREATE TABLE Departments (

CREATE TABLE Movie ( ID INT PRIMARY KEY, Title VARCHAR(10), Genre VARCHAR(10), RatingCode VARCHAR(10), Year INT ); CREATE TABLE YearStats ( Year INT,

CREATE TABLE Horse( ID INT AUTO_INCREMENT PRIMARY KEY, RegisteredName VARCHAR(30), Breed VARCHAR(30), Height DECIMAL(3,2), BirthDate DATE ); SELECT AVG(Height) AS AverageHeight FROM Horse

CREATE TABLE Movie ( ID INT PRIMARY KEY, Title VARCHAR(20), Genre VARCHAR (20), RatingCode VARCHAR(20), Year INT ); CREATE TABLE YearStats( Year INT,

CREATE TABLE Horse ( ID INT AUTO_INCREMENT PRIMARY KEY, RegisteredName VARCHAR(10), Breed VARCHAR(10), Height DECIMAL(3,2), BirthDate DATE ); SELECT RegisteredName FROM Horse

CREATE TABLE Movie ( ID INT PRIMARY KEY, Title VARCHAR(20), Genre VARCHAR(20), RatingCode VARCHAR(20), Year INT ); SELECT Title, Genre FROM Movie

CREATE TABLE Horse( ID INT AUTO_INCREMENT PRIMARY KEY, RegisteredName VARCHAR(10), Breed VARCHAR(10), Height DECIMAL(3,2), BirthDate DATE ); CREATE VIEW HorseBirthdays SELECT RegisteredName, BirthDate

CREATE TABLE Horse ( ID INT AUTO_INCREMENT PRIMARY KEY, RegisteredName VARCHAR(20), Breed VARCHAR(20), Height DECIMAL (3,2), BirthDate DATE ); ALTER TABLE Horse MODIFY COLUMN Breed VARCHAR(15);

CREATE TABLE Rating( RatingCode VARCHAR(20) PRIMARY KEY, RatingDescription VARCHAR(20) ); CREATE TABLE Movie ( Title VARCHAR (30), RatingCode VARCHAR(5), Genre VARCHAR(30), Year INT,

CREATE TABLE School( SchoolID INT UNSIGNED, SchoolName VARCHAR(50), DateConstructed DATE, OperatingBudget DECIMAL(3,1) UNSIGNED, Classification VARCHAR(1), President VARCHAR(20) ); SHOW COLUMNS

CREATE TABLE Employee( EmployeeID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Salary DECIMAL(10,2), ManagerID INT ); INSERT INTO Employee (FirstName, LastName, Salary, ManagerID)VALUES ('Robert', 'Brown', 150000.50, NULL);

CREATE TABLE YearStats ( YEAR INT PRIMARY KEY, TotalGross BIGINT UNSIGNED, Releases INT ); CREATE TABLE Movie ( ID INT PRIMARY KEY, Title VARCHAR(50), Genre VARCHAR(50),

CREATE TABLE LibraryBook ( BookID INT AUTO_INCREMENT PRIMARY KEY, Title VARCHAR(150), Author VARCHAR(150), Genre VARCHAR(50), PublishedYear INT, ShelfLocation BIGINT, ISBN VARCHAR(13) UNIQUE, IsAvailable BOOLEAN DEFAULT TRUE );

CREATE TABLE LibraryBook( BookID INT AUTO_INCREMENT PRIMARY KEY, Title VARCHAR(150), Author VARCHAR(150), Genre VARCHAR(50), PublishedYear INT, ISBN VARCHAR (13) UNIQUE, IsAvailable BOOLEAN DEFAULT TRUE );

CREATE TABLE Student( StudentID INT AUTO_INCREMENT PRIMARY KEY, NAME VARCHAR(100) UNIQUE, GradeLevel INT, Email VARCHAR(100) UNIQUE, EnrollmentDate DATE, IsActive BOOLEAN DEFAULT TRUE ); CREATE TABLE ExamScore(