Poll
click to show
601 · click to show
SQL* Challenges
Link
click to show
click to show
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
1 · 625 · Link
click to show
click to show
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🤪
2 · 716 · SQL* Challenges
Link
click to show
click to show
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
761 · SQL* Challenges
File
SQL_big_cheatsheet.pdf · 1.5 MB · click to show
SQL_big_cheatsheet.pdf · 1.5 MB · click to show
Big SQL cheat sheet with queries examples.
12 · 848 · Poll
click to show
1 · 833 · click to show
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
1K · SQL* Challenges
Photo
click to show
click to show
You may see the Products table on the picture.
Write a query to find the second highest price value in the table.
You can execute query here
Please feel free to provide your solution in the comments to this post.
SOLUTION
SELECT MAX(Price) FROM Products WHERE Price < (SELECT MAX(Price) FROM Products);
#task
4 · 967 · Poll
click to show
1 · 1K · click to show
SQL* Challenges
Photo
click to show
click to show
Orders table structure is reflected on the picture.
1) Write a query to select the average number of orders made by the customers.
2) Round the result to one decimal place.
3) The resultant field should be named as follows:
AVG OrdersNumber.
Example: Let's say if someone from clients made 3 orders, another one made 5 orders, and someone else made 2 orders. So 10 / 3, and since the result should be rounded according the the task, the output will be: 3.3.
You may practice and execute your query here
Please feel free to provide your solution in the comments to this post.
NOTE: Please use the Spoiler feature, when posting your solution, in order to give the chance to think to others.
#task
2 · 1.3K · Poll
click to show
1 · 1.3K · click to show