SQL Practice Level One

We will go through the  series of tasks to practice SQL and make our hand fine-tuned over it:


Create a table with below Data:



SQL_Example_Task_one_for_practise
Task 1 Create Table.


Post the query in a comment if you are done with the First Task.




Task 2:
Create another table:

Create table worker(Worker_ID Int Primary key, First_Name varchar(20), Last_Name Varchar (20), Joining_date Date, Department char(20));

Now Alter table and add column Salary int,




2 comments:

  1. Task 1:
    Create table professionals (Pro_ID int primary key, First_Name varchar(30), Last_Name Varchar(30), Date_Join datetime, Profession varchar(30));
    insert into professionals(Pro_ID, First_name, Last_name, Salary, Date_Join, Profession)
    Values
    (1, 'Jhony', 'Depp', 500000, '2000-04-18 09:00:00:000', 'Actor'),
    (2, 'Steve', 'Jobs', 1500000, '1983-02-04 09:00:00:000', 'CEO'),
    (3, 'Bill', 'Gates', 2500000, '1975-04-04 09:00:00:000', 'CEO'),
    (4, 'Sunder', 'Pichai', 2000000, '2016-01-01 09:00:00:000','CEO'),
    (5, 'Michale', 'Dell', 3000000, '2007-01-01 09:00:00:000', 'CEO'),
    (6, 'Mark', 'Zukerburg', 1000000, '2005-01-01 09:00:00:000', 'CEO'),
    (7, 'Under', 'Taker', 5000000, '1970-01-01 09:00:00:000', 'Wrestler'),
    (8, 'Hit', 'Man', 3400000, '1969-01-01 09:00:00:000', 'Wrestler'),
    (9, 'Lex', 'Lugar', 1500000, '1980-01-01 09:00:00:000', 'Wrestler'),
    (10, 'Shawn', 'Michale', 4500000, '1987-01-01 09:00:00:000', 'Wrestler'),
    (11, 'Dwayne', 'Johnson', 9000000, '1995-01-01 09:00:00:000', 'Actor'),
    (12, 'Steve', 'Austin', 6000000, '1990-01-01 09:00:00:000', 'Wrestler'),
    (13, 'Robie', 'William', 1000000, '1980-01-01 09:00:00:000', 'Wrestler'),
    (14, 'VInce','Mcmahon', 1500000, '1980-01-01 09:00:00:000', 'Payroll'),
    (15, 'Silvestar', 'Stallon', 10000000, '1975-01-01 09:00:00:000', 'Wrestler'),
    (16, 'Arnold', 'Swaznager', 100000000, '1976-01-01 09:00:00:000', 'Wrestler');

    Select * from professionals

    ReplyDelete
  2. Task 2:

    ALter table dbo.worker add Salary int;

    ReplyDelete

Enter your email address:

Delivered by FeedBurner