Game of thrones

 DROP TABLE IF EXISTS king;

DROP TABLE IF EXISTS battle;

CREATE TABLE king (

 k_no INT PRIMARY KEY,

 king VARCHAR(50),

 house VARCHAR(50)

);


-- Create the 'battle' table

CREATE TABLE battle (

 battle_number INT PRIMARY KEY,

 name VARCHAR(100),

 attacker_king INT,

 defender_king INT,

 attacker_outcome INT,

 region VARCHAR(50) 

);

 

INSERT INTO king (k_no, king, house) VALUES

(1, 'Robb Stark', 'House Stark'),

(2, 'Joffrey Baratheon', 'House Lannister'),

(3, 'Stannis Baratheon', 'House Baratheon'),

(4, 'Balon Greyjoy', 'House Greyjoy'),

(5, 'Mace Tyrell', 'House Tyrell'),

(6, 'Doran Martell', 'House Martell');


 

INSERT INTO battle (battle_number, name, attacker_king, defender_king, attacker_outcome, region) VALUES

(1, 'Battle of Oxcross', 1, 2, 1, 'The North'),

(2, 'Battle of Blackwater', 3, 4, 0, 'The North'),

(3, 'Battle of the Fords', 1, 5, 1, 'The Reach'),

(4, 'Battle of the Green Fork', 2, 6, 0, 'The Reach'),

(5, 'Battle of the Ruby Ford', 1, 3, 1, 'The Riverlands'),

(6, 'Battle of the Golden Tooth', 2, 1, 0, 'The North'),

(7, 'Battle of Riverrun', 3, 4, 1, 'The Riverlands'),

(8, 'Battle of Riverrun', 1, 3, 0, 'The Riverlands');


select * from battle;

select * from king;

 

Comments

Post a Comment

Popular posts from this blog

50 Essential SQL Questions to Land Your Dream Job

 CREATE TABLE worker (     first_name VARCHAR(50),     last_name VARCHAR(50),     department VARCHAR(50),     salary DECIMAL(10, 2),     joining_date DATE ); INSERT INTO worker (first_name, last_name, department, salary, joining_date) VALUES  ('John', 'Doe', 'HR', 55000, '2020-01-15'), ('Jane', 'Smith', 'Finance', 67000, '2019-03-22'), ('Robert', 'Johnson', 'IT', 72000, '2018-06-10'), ('Emily', 'Davis', 'Marketing', 59000, '2021-07-01'), ('Michael', 'Wilson', 'Sales', 63000, '2020-09-15'), ('Sarah', 'Brown', 'HR', 56000, '2022-02-19'), ('David', 'Miller', 'Finance', 68000, '2019-10-05'), ('Laura', 'Garcia', 'IT', 75000, '2020-11-22'), ('James', 'Martinez', 'Marketing', 60000, '2021-03-18'), ('Olivia...
Read more

How to find all the customers who placed orders on three consecutive days | SQL Scenario questions

  DML Script: DROP TABLE IF EXISTS Orders CREATE TABLE Orders ( customer_name VARCHAR(255), order_date DATETIME ); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-01'); INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-01'); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-02'); INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-02'); INSERT INTO Orders (customer_name, order_date) VALUES ('Charlie', '2024-04-03'); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-03'); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-04'); INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-04'); INSERT INTO Orders (customer_name, order_date) VALUES ('Charlie', '2024-04-05'); INSER...
Read more

ACCENTURE SQL INTERVIEW QUESTION | Change the ProductIDs

 DROP TABLE IF EXISTS Products; CREATE TABLE Products (     ProductID INT PRIMARY KEY,     Product VARCHAR(255),     Category VARCHAR(100) ); INSERT INTO Products (ProductID, Product, Category) VALUES     (1, 'Laptop', 'Electronics'),     (2, 'Smartphone', 'Electronics'),     (3, 'Tablet', 'Electronics'),     (4, 'Headphones', 'Accessories'),     (5, 'Smartwatch', 'Accessories'),     (6, 'Keyboard', 'Accessories'),     (7, 'Mouse', 'Accessories'),     (8, 'Monitor', 'Accessories'),     (9, 'Printer', 'Electronics');
Read more