1. Create Table Coach
CoachID INT PRIMARY KEY,
CoachName VARCHAR(20) NOT NULL,
Sports VARCHAR(15) NOT NULL,
DOJ DATE NOT NULL,
Gender CHAR(1) NOT NULL,
Salary INT NOT NULL
INSERT INTO Coach (CoachID, CoachName, Sports, DOJ, Gender, Salary)
VALUES
(1001, 'Mulund Gogoi', 'Boxing', '2004-09-01', 'M', 40000),
(1002, 'Arnab Duwara', 'Karate', '1999-10-01', 'M', 60000),
(1003, 'Nayan Bora', 'Arm Wrestling', '2005-02-28', 'M', 50000),
(1004, 'Devesh Hazarika', 'Basketball', '2010-05-05', 'M', 25000),
(1005, 'Chetan Sharma', 'Swimming', '2010-03-31', 'M', 25000),
(1006, 'Lakshmi Devi', 'Boxing', '2012-01-01', 'F', 22000);
3. Queries for Questions:
a) Display the Maximum and Minimum Salary of the Coaches
SELECT MAX(Salary) AS Max_Salary, MIN(Salary) AS Min_Salary
...
Continue reading "Creating and Managing Coach and Activity Tables in SQL" »