Let's start from the simple one.
w3schools.com platform will be used for exercising
Task #1.
- Output unique countries (Country) from the Customers table, where CustomerName does NOT start with "A" and where City is anything but London.
- Sort records in reverse order.
- Limit the number of rows to a single row.
#task
w3schools.com platform will be used for exercising
Task #1.
- Output unique countries (Country) from the Customers table, where CustomerName does NOT start with "A" and where City is anything but London.
- Sort records in reverse order.
- Limit the number of rows to a single row.
#task
Task#2.
From the Products table, select the names of all products whose price values are integers, in addition, they must be products that do not belong to the following categories (CategoryID): 1, 2, 3, 4, 5, 6.
You can try your query here
You can share your solution in comment once the task is solved.
#task
From the Products table, select the names of all products whose price values are integers, in addition, they must be products that do not belong to the following categories (CategoryID): 1, 2, 3, 4, 5, 6.
You can try your query here
You can share your solution in comment once the task is solved.
#task
Which one of the following SQL queries will delete the "customers" table and all its content from the database?
Anonymous Quiz
29%
DROP customers;
4%
DELETE customers;
19%
DELETE * FROM customers;
11%
DELETE * FROM <database> WHERE table="customers";
37%
DROP TABLE customers;
Select the only aggregation function from the list
Anonymous Quiz
4%
EXCEPT
7%
JOIN
3%
LIKE
83%
MIN
1%
EXISTS
0%
CASE
2%
IN
Which one of the following queries will limit selection by only 3 rows?
Anonymous Quiz
2%
SELECT * FROM Customers 3
77%
SELECT * FROM Customers LIMIT 3
5%
SELECT * FROM Customers 3 LIMIT
3%
SELECT 3 LIMITS * FROM Customers
14%
SELECT LIMIT(3) * FROM Customers
👍1
Interview question
You have table: Suppliers
Columns: SupplierName, Country
Question: Write one query, to select all the suppliers that are not from Brazil, Italy, Germany.
Feel free to put your solution in the comments.
You have table: Suppliers
Columns: SupplierName, Country
Question: Write one query, to select all the suppliers that are not from Brazil, Italy, Germany.
Feel free to put your solution in the comments.
Select the existing statement
Anonymous Quiz
49%
INSERT INTO SELECT
17%
INSERT INTO GROUP BY
21%
SELECT INTO INSERT
7%
UPDATE INTO INSERT
5%
SELECT INTO UPDATE
In SQL, which clause(s) of outer query may include a subquery?
Anonymous Quiz
8%
Only FROM clause
23%
WHERE and FROM clauses
8%
Only SELECT clause
60%
SELECT, FROM and WHERE clauses
Which type of JOIN doesn't exist in SQL neither as operator, nor as an approach or concept?
Anonymous Quiz
5%
Full Join
9%
Cross Join
2%
Right Join
58%
Struct Join
4%
Self Join
22%
Exclusive Join
Considering that salary is constant for 12 months,
choose the correct query to get the annual salary value per employee.
choose the correct query to get the annual salary value per employee.
Anonymous Quiz
35%
SELECT f_name, l_name, job_id, salary*12 AS Salary Per Year FROM employees;
46%
SELECT f_name, l_name, job_id, salary*12 AS "Salary Per Year" FROM employees;
6%
SELECT f_name, l_name, job_id, salary AS Salary Per Year*12 FROM employees;
12%
SELECT f_name, l_name, job_id, salary AS Salary Per Year FROM employees;