Can you explain based on this image of sql script what is wrong?
Data Warehouse Interview Questions
379 data warehouse interview questions shared by candidates
database and sql related
SQL questions Joins
What is the difference between data warehouse and data mart?
How can you prioritize work among different departments
AWS objective type questions
SQL- usage of aggregate functions, Rank, duplicate removals etc
Questions in 1st round - live coding sql - joins query, analytic function query, duplicate rows from table... etc live coding python - Compare words for 2 lists . Questions in 2nd round - ETL/data warehousing concepts, dimension modelling, project..etc Questions in 3rd round - basic discussion over project and work timings and cultural fit
What assumptions did you make in the take home challenge?
What are the different joins in SQL and explain them
Viewing 101 - 110 interview questions