Data Scientist_W2 Contract at Brilliant Infotech Inc.

4 questions, about 3 minutes. This is a diagnostic, not a certification — it estimates your skill readiness, it does not guarantee you are qualified for or will be hired into this role.

1. Which clause filters rows before they are grouped by GROUP BY?

HAVING WHERE ORDER BY LIMIT

2. You need each customer's most recent order. Which approach is most reliable?

ORDER BY order_date DESC LIMIT 1 with no grouping A window function (ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date DESC)) MAX(order_date) alone with SELECT * GROUP BY customer_id with no aggregate on the other columns

3. An INNER JOIN between orders and customers drops rows where...

the customer has no matching order the order has no matching customer both a and b nothing is dropped

4. A query aggregates revenue by region but SELECT also lists an ungrouped column. What happens on strict SQL engines (e.g. MySQL with ONLY_FULL_GROUP_BY, or PostgreSQL)?

It runs and picks an arbitrary value for the ungrouped column It errors — every selected column must be aggregated or in GROUP BY It silently returns NULL for the ungrouped column It automatically adds the column to GROUP BY

Personalized learning that starts with what you want to achieve.

Start learning

Learn

Courses
Learning paths
Roles
Skills
Jobs

Product

How it works
AI learning
Pricing
FAQ

Company

About
Blog
Contact

Legal

Privacy
Terms

What do you want to achieve? →