Genpact SQL WA2

From the "Records" table list all the students from Delhi and Mumbai.

• Select Student

  From Records

  Where city= "Delhi" OR city= "Mumbai"

• Select Student

  From Records

  Where city= "Delhi" And city= "Mumbai"

• Select Student

  From Records

  Where city= "Delhi" OR "Mumbai"

• Select Student

  From Records

  Where city= "Delhi" and "Mumbai"

What does UNIQUE keyword do?

• Returns only those values which appeared only once in the column

• Returns list of values without repetition

• Removes Duplicates

• UNIQUE keyword allows duplicate values in a column

Select all records from the Customers table, sort the result alphabetically, first by the column Country, then, by the column City.

• SELECT * FROM Customers ORDER BY City, Country;

• SELECT * FROM Customers Sort BY Country, City;

• Select * From Customers

  Order By Country, City;

• SELECT * FROM Customers Order BY Country, City desc;

Find the names from the "employee" table that has ET in the second and third positions.

• SELECT * FROM EMPLOYEE WHERE NAME LIKE '_ET_';

• SELECT * FROM EMPLOYEE WHERE NAME LIKE '%ET%;

• SELECT * FROM EMPLOYEE WHERE NAME LIKE 'ET';

• SELECT * FROM EMPLOYEE WHERE NAME LIKE '_ET%';

Select all records where the first letter of the City is an "a" or a "c" or an "s".

• SELECT * FROM CUSTOMERS WHERE CITY NOT LIKE '[acs]%';

• SELECT * FROM CUSTOMERS WHERE CITY LIKE '[acs]%';

• SELECT * FROM CUSTOMERS WHERE CITY LIKE '%[acs]%';

• SELECT * FROM CUSTOMERS WHERE CITY LIKE '[a,c,s]%';

What is used to apply filters on Result of GROUP BY based on specific conditions.

• HAVING

• WHERE

• FILTER

• LIMIT

The following SQL statement selects all products with a price between 10 and 20. In addition; do not show products with a CategoryID of 1,2, or 3

• SELECT * FROM Products WHERE Price BETWEEN 10 AND 20 AND CategoryID NOT IN (1,2,3)

• SELECT * FROM Products WHERE Price BETWEEN 10 AND 20 AND CategoryID IN (1,2,3)

• SELECT * FROM Products WHERE Price IN (10,20) AND CategoryID NOT IN (1,2,3)

• SELECT * FROM Products WHERE Price BETWEEN 10 AND 20 AND CategoryID NOT BETWEEN (1,2,3)

The following SQL statements gives all records that have city values of Miami and Atlanta but exclude any of these records that have a first name of Joe

• SELECT * FROM Customer WHERE City NOT IN (‘Miami', ‘Atlanta') AND First_name IN (‘joe')

• SELECT * FROM Customer WHERE City IN (‘Miami', ‘Atlanta') AND First_name NOT IN (‘joe')

• SELECT * FROM Customer WHERE City NOT IN (‘Miami', ‘Atlanta') AND First_name = ‘joe'

• Any One

What kind of Join is represented in the diagram alongside?

• Right Join

• Left Join

• Inner Join

• Full Outer Join

Which query will summarize the total number of matches played by each country?

• Select players, country, sum(`matches played`)

  From Games

  Group By `matches played`;

• Select *

  From Games

  Group By Country;

• Select country , sum(`matches played`)

  From Games

  Group By Country;

• Select country, count(`matches played`)

  From Games

  Group By Country;