Background

SQL sublanguage: DQL (Data Query Language)

In this lab we are going to learn how to retrieve all the records from a table.

The syntax for retrieving all rows and columns from a database table looks like the following:

SELECT * FROM table_name;

NOTE: the * is a wildcard character to retrieve all the columns from the table.

Additional reference material if needed: https://www.w3schools.com/sql/sql_select.asp

---

Lab

Problem 1

song table

title	artist
"Let it be"	Beatles
"Hotel California"	Eagles
"Kashmir"	Led Zeppelin

Problem 1: Write the SQL statement in "problem1.sql" to retrieve all the rows and columns from the table "song"

---