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

👍1

161 voters632 views08:29

SQL* Challenges

What is your speciality or desired position?

Anonymous Poll

128 voters690 views06:00

SQL* Challenges

New video for learners is now available guys, if you like it, feel free to like, subscribe and share👍👍
https://www.youtube.com/watch?v=wS2ULNE3wx8

YouTube

SQL Task Tutorial for Beginners /#2 - Two ways how to select the last record only

👍1

761 views09:18

SQL* Challenges

Which query will return the current version of the MySQL database?

Anonymous Quiz

SELECT VERSION FROM <Table_Name>;

15%

SELECT GETCURRENTVERSION();

16%

SHOW VERSION();

SELECT (VERSION);

136 voters807 views08:12

SQL* Challenges

https://youtube.com/shorts/N5thtzS6Md0?feature=share4

YouTube

SQL 4 Beginners: ✔How To Get Rounded Average?🧐 #shorts #sqlforbeginners #sql #sqlqueries

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

👍2❤1

909 views05:54

SQL* Challenges

SQL_big_cheatsheet.pdf

1.5 MB

Big SQL cheat sheet with queries examples.

👍5

848 views09:50

SQL* Challenges

Which query will return the number of ALL records from the Customers table?

Anonymous Quiz

13%

SELECT COUNT("Hello") FROM Customers;

SELECT NUM() FROM Customers;

16%

SELECT COUNT FROM Customers;

41%

SELECT COUNT(Customer) FROM Customers;

23%

None of the queries

168 voters833 views10:05

SQL* Challenges

Is it possible to sort records by the column alias?

Anonymous Quiz

58%

Yes, it is possible

16%

No, it is not possible

26%

It is possible but only when alias is used in tandem with aggregation functions

👏1

156 voters854 views08:43

SQL* Challenges

What is the important condition when we use the INSERT INTO SELECT operator?

Anonymous Quiz

48%

The data types in both tables must match.

27%

The number of records in both tables should be the same.

14%

These tables should have relations.

11%

None of the above.

😁3

140 voters993 views07:49

SQL* Challenges

SQL Task

Table name: Customers;
Field name: City;

Select all the cities which names start with S, but not end with n.

You can execute query here

Hint: If you gonna use w3schools default database, the correct request should return 11 records.

Feel free to write your answer as a comment to this task.

#task

❤1👍1

1.02K views08:21

SQL* Challenges

Is it correct to say that NULL value is the same as zero or space?

Anonymous Quiz

16%

NULL value is a synonym to 0, but space is a different thing.

Yes, all the mentioned values can be used interchangeably.

10%

It is ok, to consider NULL as a synonym to space, but 0 is a digit.

68%

No, NULL value is not equal to 0 or space.