Hey!

I'll soon provide the related content! Stay tuned!

Creating a table.

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
);

Putting up criteria in a table
CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255) 
);

Inserting in a table

INSERT INTO table_name (column1,column2, column3, ...)
VALUES (value1, value2, value3, ...);

Hey everyone ! Been a long since I posted anything. I realised that providing all the details here is meaningless as there are many better resources out there !
Keeping that in mind

Here's something for you

To minimize the impact of coronavirus outbreak on students, Progate (an online coding learning platform from Japan) has shared free access to their learning platform for all students until *30th April 2020*.

You can utilize this time at home by learning new tech skills. This will not only help you to strengthen your programming skills but will also allow you to prepare for interviews and placements.

This access includes 14 detailed online lessons of Python, Go, SQL, Command-Line and Git.

*STEPS TO ACTIVATE YOUR ACCESS:*

1) Create your free account on progate.com
2) Open this link and click the 'Join' button: bit.ly/progatespecialaccessduetocovid19
3) Open bit.ly/progatespecialaccess from a laptop/desktop and select the language

Through this you can access a very good course on SQL for FREE.

Find the Employees who hired in the Last n months. Write a SQL query for that.

Send your queries in the discussion group.

https://docs.microsoft.com/en-us/sql/t-sql/lesson-1-creating-database-objects?view=sql-server-ver15

Start your tutorial here

Write a sql query to find the second largest number from table table_name and column number.

Write a sql query to delete duplicate rows from a table.

Write a sql query to find the Joining date of Employee in YYYY-DAY-Date format.

You are given this database, your task is to output➡