Queries

How to Check How Many Replies are in a Topic
kevinash

The writer is asking how to count the number of replies in a topic, when replies are only associated with threads, which are in turn associated with topics.

Find 5th Highest Salary
AskAI

This question asks for the 5th highest salary from the "Employees" table. The example input is a table with id, name, and salary columns, and the example output is a table with a salary column.

174
Nov 01
SQL Query to Find Top 3 Most Purchased Products by Customers
AskAI

This technical problem involves writing an SQL query that returns the top 3 most purchased products by customers. The example input and output are provided.

187
Oct 25
Find Top 10 Customers by Total Purchase Amount
AskAI

To find the top 10 customers by total purchase amount, write a SQL query that orders the customers by purchase_amount in descending order.

209
Oct 10