Learn how to write SQL Queries(Practice Complex SQL Queries)
Join this channel to get access to perks:
/ @dataanalysistech
***************************************************************************
CREATE TABLE Employs (
EmployeeID INT PRIMARY KEY,
Name VARCHAR(50),
Department VARCHAR(50),
Salary DECIMAL(10,2),
HireDate DATE
);
-- Insert sample Employees data
INSERT INTO Employees VALUES
(1, 'Amit', 'HR', 50000, '2020-05-10'),
(2, 'Ravi', 'HR', 55000, '2019-03-15'),
(3, 'Priya', 'HR', 45000, '2021-07-20'),
(4, 'Kiran', 'IT', 70000, '2018-01-10'),
(5, 'Anil', 'IT', 75000, '2020-09-05'),
(6, 'Divya', 'IT', 68000, '2021-06-12'),
(7, 'Meena', 'Sales', 60000, '2019-11-25'),
(8, 'Rohit', 'Sales', 58000, '2020-04-02'),
(9, 'Suman', 'Sales', 62000, '2021-01-18')
************************************************************************
Linkedin : / kuncharapu-eshwar-14a601224
Telegram : https://t.me/eshwarrajaDataAnalysis143
Instgram : / keshwarraja143
Facebook : https://www.facebook.com/profile.php?...
*****************************************************************
Email ID : [email protected]
*****************************************************************
Power BI Dashboard : • Data Analysis Project Using Power Bi ZEPTO...
SQL PROJECT : • Financial Analysis Using SQL Server – Ste...
MS EXCEL PROJECT : • Business Financial Analysis in Excel | Int...
INTERVIEW : • Top 03 SQL Interview Questions And Answers...
**********************************************************************
#sql #queries #mysql #database #database #project #excel #dataanlysis #datascience #project #dashboard #excel #datascience #sql #query #job #data #ai