Answer Happy

First fill the table below using insert into command any values you want second , Write sql queries of your choice that contain the required :
i. Run at least 10 advanced queries on your
including the following SQL keywords:
1. Union/lntersect/Difference
2. Distinct, aggregate functions, In, Between,
ISNULL, NOT, LIKE
3. Nested queries, comparison queries (ALL/ANY),
Group By, Order By, Having, INTO, Case expression,
and compute clause.
i. Use DML (Data Manipulation Language) for
(insert/update/delete).
ii. Create a database objects, such as : Index ,
Procedure or Function, Trigger and Asseration
And at least one DDL (Data Definition Language)
such as Create Table.
Example of a query :
SELECT * FROM costumer
ORDER BY CFname ;
create database Gym; use Gym; create table costumer cID integer primary key, CFname char(10) not null, CMname char(10) not null, CLname char(10) not null, CPhone Number numeric not null, Age numeric not null, Weight decimal not null, Length decimal not null); create table managers ManagerID integer primary key, MFname char(10) not null, MMname char(10) not null, MLname char(10) not null, MPhone Number numeric not null); create table trainer TrainerID integer primary key, TFname char(10) not null, TMname char(10) not null, TLname char(10) not null); create table equipment EquipmentID integer primary key, Ename char(50) not null, Etype char(50) not null); create table classes RoomID integer primary key, ClassName char(20) not null, Class Time time not null); create table membership MembershipID integer primary key, Mperiod integer not null, Expiry Date date not null);

create table payment PaymentID integer primary key, ApplePay decimal not null, Cash decimal not null, Credit Card decimal not null); create table guest GuestID integer primary key, Gname char(20) not null, GAge numeric not null); create table address_coustomer address ID integer references customer (CID), address char(20) not null create table phone_coustomer phone D integer references customer (cID), phone integer(20) not null create table coustomer_equipment ( EQ_ID integer references equipment(ECID), coustomerID integer references customer (cID) ); create table Class_trainer room_ID integer references classes (RoomID), TrainerID integer references trainer TrainerID) );