Complex SQL Interview Question | Coding Challenges | SQL Analytical Functions
In this video we will solve a complex sql interview question.
Question:
Julia asked her students to create some coding challenges. Write a query to print the hacker_id, name, and the total number of challenges created by each student. Sort your results by the total number of challenges in descending order. If more than one student created the same number of challenges, then sort the result by hacker_id. If more than one student created the same number of challenges and the count is less than the maximum number of challenges created, then exclude those students from the result.
Table Script:
create table hackers(
hacker_id int,
name varchar(20)
)
create table challenges(
challenge_id int,
hacker_id int
)
insert into hackers(hacker_id, name)
values(12299,'rose'),(34856,'angela'),(79345,'frank'),
(80491,'patrick'),(81041,'lisa'),(70978,'john')
insert into challenges(challenge_id, hacker_id)
values(63963,81041),(63117,79345),(28225,34856),
(21989,12299),(4653,12299),(70070,79345),
(36905,34856),(61136,80491),(17234,12299),
(80308,79345),(40510,34856),(79820,80491),
(22720,12299),(21394,12299),(36261,34856),
(15334,12299),(71435,79345),(23157,34856),
(54102,34856),(69065,80491),(63953,70978),
(63127,70978),(28105,70978),(11129,70978)
🔍 Looking for something specific? Check out my curated playlists.
✅Complex SQL Interview Questions
• Complex SQL Interview Questions: Mastering...
✅SQL Interview Questions
• SQL Interview Bootcamp: Questions & Practi...
✅SQL Mastery Interview Prep
• SQL Concepts: Detailed Interview Questions...
✅Learn SQL Concepts
• SQL Fundamentals: Key Concepts and Skills
✅SQL Functions
• SQL Functions Explained: Practical Uses an...
Don't forget to hit the subscribe button and ring the notification bell to never miss an update! Become a valued member of our passionate community and be part of the journey with me!
Thanks for watching, and see you in the next video!" 🚀
#sqlinterview #sqlinterviewquestionsandanswers #sql #sqlforbeginners #sqlserver
sql interview questions, data analyst interview questions, data engineer interview questions, data scientist interview questions, sql interview preparation, sql questions and answers, advanced sql interview questions, sql for data analysts, sql for data engineers, sql for data science, real world sql questions, tricky sql interview questions, sql practice questions, sql coding interview, data analytics interview questions, analytics interview prep, data engineering interview prep, data science interview prep, sql joins interview questions, window functions sql interview, sql case when interview questions, sql aggregation questions, group by sql interview, sql query practice, learn sql fast, sql tutorial for beginners, sql for beginners, sql problems with solutions, database interview questions, mysql interview questions, postgresql interview questions, top sql interview questions, faang data analyst interview, faang data engineer interview, business analyst sql questions, sql scenarios interview, hands on sql practice, sql mock interview, data analyst sql project, data engineer sql project
На этой странице сайта вы можете посмотреть видео онлайн Complex SQL Interview Question | Coding Challenges | SQL Analytical Functions длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Data Project Hub 04 Апрель 2024, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 546 раз и оно понравилось 16 зрителям. Приятного просмотра!
