SQL Interview Prep

You are a data analyst. Finance interview. Return all rows and columns.

You are a data analyst. Finance interview. Return only the category and number columns.

You are a data analyst. Finance interview. Return rows for one category.

You are a data analyst. Finance interview. Return rows where the number is above 5.

You are a data analyst. Finance interview. Sort rows largest number first.

You are a data analyst. Finance interview. Return the top 3 rows by number.

You are a data analyst. Finance interview. How many rows are in the table?

You are a data analyst. Finance interview. Return the total of the number column.

You are a data analyst. Finance interview. Return the average number.

You are a data analyst. Finance interview. Return the smallest and largest numbers.

You are a data analyst. Finance interview. List each category once.

You are a data analyst. Finance interview. Return the number column renamed as value.

You are a data analyst. Finance interview. Rows in one category AND number above 1.

You are a data analyst. Finance interview. Rows where number is below 3 OR above 50.

You are a data analyst. Finance interview. Rows whose category is in a list of two.

You are a data analyst. Finance interview. Rows with number between 1 and 50.

You are a data analyst. Finance interview. Categories starting with the first letter of the pick.

You are a data analyst. Finance interview. Count rows per category.

You are a data analyst. Finance interview. Total number per category.

You are a data analyst. Finance interview. Categories with more than 1 row.

You are a data analyst. Finance interview. Category totals, largest first.

You are a data analyst. Finance interview. Label each row High or Low.

You are a data analyst. Finance interview. Count rows of the pick category without WHERE.

You are a data analyst. Finance interview. Find rows where the number is missing.

You are a data analyst. Finance interview. Show 0 when the number is missing.

You are a data analyst. Finance interview. Rows with number above the average.

You are a data analyst. Finance interview. Join the table to a targets table on category.

You are a data analyst. Finance interview. Keep all rows even without a target.

You are a data analyst. Finance interview. Rows that have no target.

You are a data analyst. Finance interview. Categories that appear more than once.

You are a data analyst. Finance interview. Stack the pick rows and big rows without repeats.

You are a data analyst. Finance interview. Rows whose category has a target.

You are a data analyst. Finance interview. Each category's share of the total.

You are a data analyst. Finance interview. Create the table with the right types.

You are a data analyst. Finance interview. Rank rows by number, biggest first.

You are a data analyst. Finance interview. Rank rows inside each category.

You are a data analyst. Finance interview. Largest row in each category.

You are a data analyst. Finance interview. Return the second highest number.

You are a data analyst. Finance interview. Cumulative total ordered by id.

You are a data analyst. Finance interview. Show each row's previous number and the change.

You are a data analyst. Finance interview. 3-row moving average.

You are a data analyst. Finance interview. Show each row next to its category average.

You are a data analyst. Finance interview. Use two CTEs to find categories above the overall average.

You are a data analyst. Finance interview. Delete duplicate categories, keeping the first id.

You are a data analyst. Finance interview. Pairs of rows in the same category.

You are a data analyst. Finance interview. One column per category total.

You are a data analyst. Finance interview. Split rows into 2 buckets by number.

You are a data analyst. Finance interview. Insert a row or update it if the id exists.

You are a data analyst. Finance interview. Create an index to speed up category filters.

You are a data analyst. Finance interview. Group consecutive rows of the same category.