SQL Training Class 3

As part of Class 3, Covering the SQL Inbuilt functions on how to use when we are writing SQL queries. This video helps you to improve the efficiency of SQL writing.

Exercise: Below is the table script (EmployeeDetails) along with the data
/****** Object: Table [dbo].[EmployeeDetails] Script Date: 6/18/2021 11:28:26 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EmployeeDetails](
[EmpID] [int] NULL,
[Name] [varchar](20) NULL,
[Department] [varchar](10) NULL,
[City] [varchar](10) NULL,
[Salary] [money] NULL,
[Mobile] [varchar](10) NULL,
[dob] [date] NULL,
[JoiningDate] [date] NULL,
[IsActive] [bit] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (8, N'Abhishek', N'IT', N'Bangalore', 45000.0000, N'890993434', CAST(N'2001-02-02' AS Date), CAST(N'2021-05-05' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (7, N'Arihant', N'IT', N'Hyderabad', 45000.0000, N'890993434', CAST(N'2001-02-02' AS Date), CAST(N'2021-05-05' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (3, N'Hari', N'IT', N'Bangalore', 39000.0000, N'899934344', CAST(N'2001-03-04' AS Date), CAST(N'2020-04-11' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (8, N'Accenture', N'IT', N'Hyderabad', 33000.0000, N'880034566', CAST(N'2000-03-04' AS Date), CAST(N'2021-11-05' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (5, N'Sharma', N'HR', N'Bangalore', 80000.0000, N'343434343', CAST(N'2000-05-06' AS Date), CAST(N'2021-04-11' AS Date), 0)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (9, N'IBM', N'IT', N'Hyderabad', 39000.0000, N'', CAST(N'2001-03-04' AS Date), CAST(N'2020-04-11' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (2, N'Sowmya', N'IT', N'Bangalore', 55000.0000, N'880034566', CAST(N'2000-03-04' AS Date), CAST(N'2021-11-05' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (4, N'Nitin', N'HR', N'Bangalore', 76000.0000, N'893434344', CAST(N'1999-01-01' AS Date), CAST(N'2020-12-11' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (6, N'Shankar', N'HR', N'Bangalore', 30000.0000, N'323242424', CAST(N'1999-11-11' AS Date), CAST(N'2021-02-03' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (10, N'Capgmeini', N'HR', N'Hyderabad', 76000.0000, N'893434344', CAST(N'1999-01-01' AS Date), CAST(N'2020-12-11' AS Date), 1)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (11, N'TCS', N'HR', N'Hyderabad', 44000.0000, N'343434343', CAST(N'2000-05-06' AS Date), CAST(N'2021-04-11' AS Date), 0)
GO
INSERT [dbo].[EmployeeDetails] ([EmpID], [Name], [Department], [City], [Salary], [Mobile], [dob], [JoiningDate], [IsActive]) VALUES (12, N'Infosys', N'HR', N'Hyderabad', 30000.0000, N'323242424', CAST(N'1999-11-11' AS Date), CAST(N'2021-02-03' AS Date), 1)
GO


Questions to Answer:

-- 1. Write a query to extract first and last3 characters from Name Column
-- 2. Display Current Date
-- 3. Calculate Total Salary for all the employees
-- 4. Write a query to find MAX and MIN Salary of employees
-- 5. Write a query to COUNT total employess
-- 6. Tell the date differnce in days for the employee JoiningDate and CurrentDate
-- 7. Tell the employee joining day name
-- (Ex: If 2021-05-05 is the joining date of employee you need to tell which day it is like Monday, Tuesday ...)
-- 8. Write a query to convert the datatype of EmpID to INT