We have a table, which is named History as follows: 1. Write an SQL SELECT state

Question

We have a table, which is named History as follows:

1.      Write an SQL SELECT statement to list the contents of the table in order of birthdate.

2.      Write an SQL SELECT statement to list the contents of the table in order of birthdate and name.

3.      Write an SQL INSERT statement to add the Yahoo founder David Filo (1966_) to the table.

4.      Write an SQL INSERT statement to add the semiconductor pioneer William B. Shockley (1910_1989) to the table.

5.      Write an SQL statement to modify record 4 to include

Explanation / Answer

Dear, 1. SELECT * FROM history ORDER BY Born 2. SELECT * FROM history ORDER BY Born , First_name 3. INSERT INTO history (Record_num,Last_name,First_name,Born,Known_for) VALUES (7,”Filo”,”David”1966,”Yahoo Founder”) 4. INSERT INTO history (Record_num,Last_name,First_name,Born,Died,Known_for) VALUES (7,”B.Shockley”,”William”1966,1989,”Semiconductor pioneer”) 5. UPDATE history SET Known_for=”Telescope” WHERE Record_num=4 6. DELETE FROM history WHERE First_name=’ John’ Last_name=’Napier’ Hope this will help you..

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.