Coding interview preparation
5.82K subscribers
392 photos
68 files
164 links
Download Telegram
Explanation:
Stack follows Last In First Out (LIFO) policy. Piling up of chairs one above the other is based on LIFO, people standing in a line is a queue and if the service is based on priority, then it can be associated with a priority queue. Tatkal Ticket Booking Follows First in First Out Policy. People who click the book now first will enter the booking page first.
๐Ÿ‘1
Forwarded from Web development
๐Ÿ‘2โค1
Sorry I've forwarded it wrong, here is a complete post:
Forwarded from Web development
5 Valuable Web Development cheat sheets ๐Ÿ‘†
๐Ÿ‘2
image_2025-01-31_16-39-23.png
143.1 KB
Common Data Structure Operations and
Array Sorting Algorithms

It could be useful to have it as a cheat sheet
๐Ÿ‘3
SC15.png
195.6 KB
SQL EXECUTION ORDER

SQL Doesnโ€™t Run the Way You Think It Does!

Most people assume SQL runs top to bottomโ€”
but in reality, the database follows a completely different process.

Hereโ€™s what actually happens when you hit Run:

๐Ÿ”น FROM & JOIN โ€“ First, SQL figures out where to pull the data from.
๐Ÿ”น WHERE โ€“ Then, it filters out rows that donโ€™t match your conditions.
๐Ÿ”น GROUP BY โ€“ If needed, it groups the remaining rows together.
๐Ÿ”น HAVING โ€“ Now, it filters those groups (not individual rows).
๐Ÿ”น SELECT โ€“ Finally, it picks the columns you asked for.
๐Ÿ”น ORDER BY โ€“ It sorts the result.
๐Ÿ”น LIMIT โ€“ At the very end, it restricts the output.

Why does this matter?
โคท You canโ€™t use column aliases in WHERE
because SELECT runs later.
โคท Filtering after grouping (HAVING)
is less efficient than filtering before (WHERE).
โคท Understanding this helps you write faster, better queries.

Most analysts assume SQL reads queries like English.
โœ… But databases have their own logicโ€”and mastering it makes
you a 10x better analyst!
๐Ÿ‘4
Python Interview Questions
๐Ÿ‘3โค1