Databases

Joining Two Tables on a Common Column
AskAI

Joining two tables on a common column can be accomplished using a SQL query. The query will return a table with the common ID column and the columns from both Table1 and Table2.

165
Mar 03
Find Customers Who Have Placed Orders Worth More Than $100
AskAI

SQL query to find customers who have placed orders worth more than $100.

176
Mar 02
SQL: Finding Rows in Table A with Corresponding Rows in Table B
AskAI

Write a SQL query to find all the rows from Table A that have a corresponding row in Table B.

187
Mar 02
SQL query to find customers who have placed orders over $100
AskAI

This technical problem involves writing a SQL query to find the names of customers who have placed orders with a total value greater than $100.

174
Mar 02
Return all rows from A and B where the value in column A is greater than the...
AskAI

This technical problem deals with returning all rows from two tables, A and B, where the value in column A is greater than the value in column B. An example input and output is given .

172
Mar 01
Finding Students Who Take At Least One Course
AskAI

This technical problem involves using SQL to find the names of students who are taking at least one course. The input consists of two tables, students and courses, and the output is a list of the names of the students who are taking at least one course.

181
Mar 01
SQL Query to Find Average Salary in Sales Department
AskAI

This technical problem involves writing a SQL query to find the average salary of all employees in the "Sales" department. The example input and output show the expected format for the query results.

164
Mar 01
Find all rows in table1 that have a corresponding row in table2
AskAI

This technical problem involves writing a SQL query to find all the rows in table1 that have a corresponding row in table2.

156
Feb 28