SQL* Challenges

Which of the following queries can be used to select all the records in the Employees table that have a LastName field value alphabetically between (and including) Davolio and Watson?

Anonymous Quiz

77%

SELECT * FROM Employees WHERE LastName BETWEEN 'Davolio' AND 'Watson'

21%

SELECT * FROM Employees WHERE LastName > 'Davolio' AND LastName < 'Watson'

SELECT LastName > 'Davolio' AND LastName < 'Watson' FROM Employees

👍3

121 voters715 views09:05

SQL* Challenges

Which one is the correct example of using the CONCAT function?

Anonymous Quiz

10%

SELECT CONCAT IN (Name, Surname) FROM Clients;

14%

SELECT CONCAT = (Name, " ", Surname) AS "Full Name" FROM Clients;

63%

SELECT CONCAT(Name, " ", Surname) AS "Full Name" FROM Clients;

13%

SELECT Name, Surname FROM Clients WHERE CONCAT = (SELECT Name, Surname FROM Clients);

👍1

132 voters726 views07:02

SQL* Challenges

For what purposes NATURAL JOIN can be used?

Anonymous Quiz

23%

To get all the unique columns from joined tables.

19%

To select only those columns that have the same names from tables to be joined.

16%

There is no such thing as NATURAL JOIN.

43%

NATURAL JOIN is 100% the same as INNER JOIN.

👍4

120 voters688 views07:18

SQL* Challenges

Task#3
Write a query that will display the FirstName of the employee who processed the most orders between 1996-09-02 and 1996-12-31.

Used tables: Orders, Employees.

You can use w3schools db for writing a query.

As soon as you're done with the task, feel free to share the name of the employee in the comment section to this task (but don't share the code itself, in order not to make a spoiler for others😉)

#task

620 viewsedited 13:15

SQL* Challenges

Solution to Task#3

SELECT Employees.FirstName
FROM [Orders]
JOIN Employees USING(EmployeeID)
WHERE OrderDate BETWEEN "1996-09-02" AND "1996-12-31"
GROUP BY EmployeeID ORDER BY COUNT(*) DESC LIMIT 1

#task

👏3

603 viewsedited 07:00

SQL* Challenges

What is the difference between UNION and INTERSECT?

Anonymous Quiz

77%

UNION combines results from both queries, INTERSECT gets results that only exist in both queries.

10%

INTERSECT combines results from both queries, UNION gets results that only exist in both queries.

UNION and INTERSECT are basically the synonyms and can be used interchangeably

INTERSECT can be considered as UNION but with extended functionality and set of options.

👍2❤1

132 voters656 views10:55

SQL* Challenges

👍1

598 views08:56

SQL* Challenges

Given the following table (see the image above).

Which one of the following queries will select top 8 high-paying employees?

Anonymous Quiz

18%

SELECT COUNT(8), salary FROM employees WHERE salary=MAX(salary);

24%

SELECT * FROM employees WHERE salary=(SELECT MAX(salary) FROM employees) LIMIT 8;

49%

SELECT * FROM employees ORDER BY salary DESC LIMIT 8;

SELECT first_name, last_name, position, MAX(salary) FROM employees GROUP BY employee_id LIMIT 8;

139 voters601 views08:58

SQL* Challenges

Hello guys!👋👋

If you like the idea of this short video, please like and subscribe⭐️

If you know learners for whom such content will be most useful, feel free to share💪💪

Your feedback is motivating me to keep doing things like this, and to support people who want to become a part of the IT sphere!🌟

Thanks you, and may the Force be with all of us!🚀

#shorts

YouTube

SQL 4 Beginners: ✔How To Select Values With More Than One Word?😳 #shorts #sqlforbeginners #sql

#shorts #sql #sqlqueries #sqlforbeginners #sqltutorial #sqltutorialforbeginners #learnsql #sqlinterview #sqlinterviewquestionsandanswers #sql #qualityassuran...

👍3

625 viewsedited 08:08

SQL* Challenges

'View' in SQL is a synonim to:

Anonymous Quiz

149 voters611 views09:28

SQL* Challenges

What is INDEX in database?

Anonymous Quiz

21%

Index is basically the same as Primary Key.

56%

Index is a DB structure that is used to improve the performance of queries.

Index is always a combination of Primary and Foreing keys.

15%

Index just means the first record in the table with the lowest ID.

135 voters623 views06:51

SQL* Challenges

Hello guys!👋

Try this Job Interview Simulation Task.

Once the task was displayed, stop the video, right a query, and then see the answer😉💪

And yes, if you like it, you know what to do🤪

YouTube

SQL Task Tutorial for Beginners /#1 - Selection outside the given set

Join our Telegram channel to have more quizzes and tasks with answers: t.me/SQL_Challenges

You may use the following platform to practice SQL queries:
www.w3schools.com/sql/

#shorts #sql #sqlqueries #sqlforbeginners #sqltutorial #sqltutorialforbeginners…

❤2👍1

716 viewsedited 07:28

SQL* Challenges

If you need to delete the entire content from the table but keep the table structure, which command will you use?

Anonymous Quiz