pls help me to get query for below problems: SQL Test 1: A table has three columns - id (primary key), categoryID (numeric) and amount (numeric). The goal is to provide a query that would show categoryID and sum of amounts within that category where categoryID is an odd number and sum of amounts is greater than 100,000
SQL Test 2
There are two tables - Table1 (table1_id, value1) and Table2 (table2_id, table1_id, value2). The field Table2.table1_id is a foreign key to Table1.table1_id. It is necessary to write a SQL query that would find all records in Table1 that do not have a corresponding record in Table2. The query should not use sub-selects.
View All Comments
| View Tutorial