# POS410 Week 3 Quiz – Perfect solution guaranteed

Lab Price = \$4
Payment methods

Problem Statement

POS 410 Week 3 Quiz
1. With SQL, how do you select all the columns from a table named “Persons”?
a. SELECT *.Persons
b. SELECT Persons
c. SELECT * FROM Persons
d. SELECT [all] FROM Persons
2. With SQL, how do you select all the records from a table named “Persons” where the value of
the column “FirstName” is “Peter”?
a. SELECT * FROM Persons WHERE FirstName LIKE ‘Peter’
b. SELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’
c. SELECT * FROM Persons WHERE FirstName=’Peter’
d. SELECT [all] FROM Persons WHERE FirstName=’Peter’
3. With SQL, how do you select all the records from a table named “Persons” where the value of
the column “FirstName” starts with an “a”?
a. SELECT * FROM Persons WHERE FirstName=’%a%’
b. SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
c. SELECT * FROM Persons WHERE FirstName=’a’
d. SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
4. WITH SQL, how do you select all the records from a table named “Persons” where the value of
the column “age” is between 21 and 31?
a. SELECT * FROM Persons WHERE age BETWEEN 21 AND 31
b. SELECT * FROM Persons BETWEEN 21 AND 31
c. SELECT * FROM Persons WHERE age <= 31 5. WITH SQL, how do you calculate the total number of people from a table named “Persons” where the value of the column “LastName” is “Smith”? a. SELECT TOTAL FROM Persons WHERE LastName = ‘Smith’ b. SELECT LastName, COUNT(*) FROM Persons WHERE LastName = ‘Smith’ GROUP BY LastName c. SELECT COUNT FROM Persons WHERE LastName = ‘Smith’ ON LastName

Relevant Material
Instructions
* If you want to purchase multiple products then click on “Buy Now” button which will give you ADD TO CART option.Please note that the payment is done through PayPal.
* You can also use 2CO option if you want to purchase through Credit Cards/Paypal but make sure you put the correct billing information otherwise you wont be able to receive any download link.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please wait for atleast 8 hours for a response from our side. Afterall, we are humans.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.