Heres the solution for: URI Online Judge SQL Problem no. 2623 - Categories with Various Products.

Display the product name and category name for products whose amount is greater than 100 and the category ID is 1,2,3,6 or 9. Show the results in ascendent order by category ID

Problem Details

Sample Output

name        |      name
Red Chair   |   Super Luxury