write SQL statements with attached database for the following queries.

1. Add a new record to the Supplier table for a supplier whose supplier number is 'S6', Name is 'Peter', and status/location are unknown. 
2. Get all the detailed info for suppliers whose status is less than 10 
3. Get a list of all different values in the SNAME column of S table 
4. Get part numbers and part names for those parts located in 'London' 

Tables (S-SP-P)

S#	SNAME	STATUS	CITY
S1	SMITH	20	LONDON
S2	JONES	10	PARIS
S3	BLAKE	30	PARIS
S4	CLARKE	20	LONDON
S5	ADAMS	30	ATHENS

Supplier (S)

 

S#	P#	Qty
S1	P1	300
S1	P2	200
S1	P3	400
S1	P4	200
S1	P5	100
S1	P6	100
S2	P1	300
S2	P2	400
S3	P2	200
S4	P2	200
S4	P4	300
S4	P5	400

SP

 

P#	Pname	Colour	Weight	City
P1	BOLT	blue	10	London
P2	NUT	black	5	Paris
P3	WASHER	black	2	London
P4	NUT	red	6	Athens
P5	CAM	red	8	Paris
P6	NUT	blue	5	London

Answer rating: 100% (QA)

Here are SQL queries for each operation 1 Add a new record to the Supplier table f... View the full answer