SQL Coding Practice 1

1.

Create a student table to store name, age and score of students.

details	datatype
name	string of max length 200
age	integer
score	integer

2.

In a typical e-commerce application, we need to store the following customer details. Create a customer table to store the data.

details	datatype
customer_id	integer
first_name	string of max length 200
last_name	string of max length 200
date_of_birth	date
address	text
phone_number	integer

3.

We need to store the details of orders in an e-commerce application. Create an order_details table to store the following details for every order.

details	datatype
order_id	integer
customer_id	integer
order_datetime	datetime
shipped_datetime	datetime
total_amount	float

4.

We're storing the details of players who are a part of a tournament. The database contains a player table that stores the name, age and score of players.

We have to add a new player to the

player

table.

details	value
name	Ram
age	28
score	30

5.

The database contains a player table that stores the name, age and score of players. Get all the players from the player table in the following format.

Expected Output Format:

name	age	score
Suresh	21	70
Venkat	21	43
---	---	---

6. Get all the details of "Suresh" from the player   table in the following format.

Expected Output Format:

name	age	score
Suresh	21	70