SQLize | PHPize | SQLtest

CREATE TABLE People ( Id int NOT NULL IDENTITY, FirstName varchar(100) NOT NULL, LastName varchar(100) NOT NULL ) -- ** Problem 1: Insert the following names into the People table: -- Eric Powers -- Eric Masters -- Luke Sissybird -- Luke Nadaqueso -- Suzie McPlanet -- Zoe McAnyone Insert People values ('Eric','Powers') Insert People values ('Eric','Masters') Insert People values ('Luke','Sissybird') Insert People values ('Luke','Nadaqueso') Insert People values('Suzie','McPlanet') Insert People values ('Zoe','McAnyone') -- Write the statement here: -- ** Problem 2: Duplicate each FirstName / LastName combination in the People table without -- using the same insert statements from Problem 1. Insert into People values from (Select FirstName,LastName from People) -- Write the statement here: -- ** Problem 3: Write a query that finds all records where the last name ends with the letter "n". -- Write the statement here: -- ** Problem 4: Write a query without using the "WHERE" keyword which returns results -- in the following format: -- FirstName Cnt -- Suzie 2 -- Zoe 2 -- Write the statement here: