CodeSpace💎

CLEAN CODE

[CodeSpace💎 @codespace_x]

Can you solve this?

[CodeSpace💎 @codespace_x]

#9

[CodeSpace💎 @codespace_x]

#8

[CodeSpace💎 @codespace_x]

#solution #7

[CodeSpace💎 @codespace_x]

#7

[CodeSpace💎 @codespace_x]

#7

[CodeSpace💎 @codespace_x]

#solution #6

[CodeSpace💎 @codespace_x]

#6

[CodeSpace💎 @codespace_x]

#6

[CodeSpace💎 @codespace_x]

#5

[CodeSpace💎 @codespace_x]

#Solutions #4

[CodeSpace💎 @codespace_x]

#4

[CodeSpace💎 @codespace_x]

#4

[CodeSpace💎 @codespace_x]

#Solution #3

[CodeSpace💎 @codespace_x]

#3

[CodeSpace💎 @codespace_x]

Master SQL and everything will be given to you!

[samdesign @samdesign_01]

DA to DA, try to learn and master SQL. Don't based your whole learning on Excel, Power BI, and Dashboard.

Most of the data jobs required database and SQL knowledge.

Know this and stay updated.

[Folake❤️🦋 @a_beelkiss]

SELECT student_id, name, grade, class
FROM (
SELECT student_id, name, grade, class,
ROW_NUMBER() OVER (PARTITION BY class ORDER BY grade DESC) as rank
FROM students
) ranked_students
WHERE rank <= 3
ORDER BY class, grade DESC;

[CodeSpace💎 @codespace_x]

@a_beelkiss Try using CTEs as well. They’re more performant than subquery

[CodeSpace💎 @codespace_x]

#3

[CodeSpace💎 @codespace_x]

Here you are!

[CodeSpace💎 @codespace_x]

#2

[Folake❤️🦋 @a_beelkiss]

SELECT department, name, hire_date, salary
FROM employees e1
WHERE hire_date = (
SELECT MAX(hire_date)
FROM employees e2
WHERE e2.department = e1.department
);

[CodeSpace💎 @codespace_x]

#2

[CodeSpace💎 @codespace_x]

Here you are!

[CodeSpace💎 @codespace_x]

Drop your script in comments

[CodeSpace💎 @codespace_x]

Drop your script in comments

[CodeSpace💎 @codespace_x]

Memory refresher!