Complex SQL Interview Question | Coding Challenges | SQL Analytical Functions

Publicado el: 04 abril 2024
en el canal de: Data Project Hub

546

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

En esta página del sitio puede ver el video en línea Complex SQL Interview Question | Coding Challenges | SQL Analytical Functions de Duración hora minuto segunda en buena calidad , que subió el usuario Data Project Hub 04 abril 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 546 veces y le gustó 16 a los espectadores. Disfruta viendo!