My issue
check if this code is correct
My code
/* Click on 'Next' to proceed */
-- Creating a new database
CREATE DATABASE IF NOT EXISTS SampleDB;
-- Switching to the newly created database
USE SampleDB;
-- Creating a new table
CREATE TABLE IF NOT EXISTS Employee (
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Age INT,
Salary DECIMAL(10, 2)
);
-- Inserting data into the table
INSERT INTO Employee (EmployeeID, FirstName, LastName, Age, Salary)
VALUES
(1, 'John', 'Doe', 30, 50000.00),
(2, 'Jane', 'Smith', 25, 45000.00),
(3, 'Bob', 'Johnson', 35, 60000.00),
(4, 'Alice', 'Williams', 28, 52000.00);
-- Updating data in the table
UPDATE Employee
SET Salary = 55000.00
WHERE EmployeeID = 2;
-- Deleting a record from the table
DELETE FROM Employee
WHERE EmployeeID = 4;
-- Selecting data from the table with conditions
SELECT *
FROM Employee
WHERE Age BETWEEN 25 AND 35
AND LastName LIKE 'D%';
-- Using aggregate functions
SELECT COUNT(*) AS TotalEmployees,
AVG(Age) AS AverageAge,
MAX(Salary) AS MaxSalary,
MIN(Salary) AS MinSalary,
SUM(Salary) AS TotalSalary
FROM Employee;
-- Grouping data and applying conditions using GROUP BY and HAVING
SELECT FirstName, COUNT(*) AS RecordCount
FROM Employee
GROUP BY FirstName
HAVING COUNT(*) > 1;
Learning course: SQL at Work
Problem Link: Beginner level SQL Practice Problem in SQL at Work - CodeChef