(Solved) : Create Table Member First Name Varchar 20 Last Name Varchar 20 Phone Number Int Address Va Q29878663 . . . .

Create table Member (First name Varchar(20),Last nameVarchar(20),Phone number Int,Address Varchar(30),Payment codeVarchar(20),Payment method Varchar(20),Type membershipVarchar(20),Schedule Int);

Insert into Member (First name Varcahr(20),Last nameVarchar(20),Phone number Int,Address Varchar(30),Payment codeVarchar(20),Payment method Varcahr(20),Type membershipVarchar(20),Schedule Int);

Insert Into Member Values(‘Amy’,’Jhonson’,’7708900123′,’5100Harbins Point’,’01’,’Credit Card’,’Basic’,’40’);

Insert Into Member Values(‘Brad’,’Knight’,’4047860093′,’4109Morning Mist’,’02’,’Cash’,’Pro’,100′);

Insert Into Member Values(‘Charles’,’Stephen’,’6780127803′,’1009Johns Creek’,’03’,’Credit Card’,’Super’,’202′);

Update Member

Set Type membership= ‘Basic’

Where Schedule = ’40’;

Please fix this SQL query and run it in MS SQL servertoo

Expert Answer

An answer will be send to you shortly. . . . .