How to retrieve data for more than 2 tables in SQL?

 DML Script:


 -- Create Departments table

CREATE TABLE Departments (

    DepartmentID VARCHAR(10) PRIMARY KEY,

    DepartmentName VARCHAR(50)

);


-- Create Employees table

CREATE TABLE Employees (

    EmployeeID INT PRIMARY KEY,

    Name VARCHAR(50),

    DepartmentID VARCHAR(10) 

);


-- Create Projects table

CREATE TABLE Projects (

    ProjectID VARCHAR(10) PRIMARY KEY,

    ProjectName VARCHAR(50),

    DepartmentID VARCHAR(10) 

);


-- Insert data into Departments table

INSERT INTO Departments (DepartmentID, DepartmentName) VALUES

('D001', 'HR'),

('D002', 'Finance'),

('D003', 'IT');


-- Insert data into Employees table

INSERT INTO Employees (EmployeeID, Name, DepartmentID) VALUES

(1, 'John Smith', 'D001'),

(2, 'Jane Doe', 'D002'),

(3, 'Sam Brown', 'D001'),

(4, 'Linda White', 'D003');


-- Insert data into Projects table

INSERT INTO Projects (ProjectID, ProjectName, DepartmentID) VALUES

('P001', 'Project X', 'D001'),

('P002', 'Project Y', 'D002'),

('P003', 'Project Z', 'D003'),

('P004', 'Project A', 'D001');




SELECT * FROM Departments

SELECT * FROM Projects

SELECT * FROM Employees

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