This technical problem deals with writing a SQL query to find the number of distinct values in each column of a table. The input is a table with two columns, and the output is the number of distinct values in each column.
Query a database for customers who live in a given state and have made a purchase within the past 30 days.
Write a SQL query to find all pairs of rows in a table where the values in the two columns are within 10% of each other.
To find the top 10 most common values in a given column with millions of rows, you can use a SQL query.
This technical problem involves writing a SQL query that returns the id, name, and salary of all employees with a salary greater than $50,000.