Simply SQL

Sample Applications & Examples

• Teams & Games
  1. Teams_01_CREATE_ALTER_DROP.sql
  2. Teams_02_INSERT.sql
  3. Teams_03_DELETE_INSERT.sql
  4. Teams_04_UPDATE.sql
  5. Teams_05_DELETE.sql
  6. Teams_06_FROM_teans.sql
  7. Teams_07_Games.sql
• Content Management System
  1. CMS_01_Title_and_Category_of_Entries.sql
  2. CMS_02_Display_an_Entry.sql
  3. CMS_03_Count_Entries_by_Category.sql
  4. CMS_04_Entries_Sorted_Latest_First.sql
  5. CMS_05_Categories_INNER_JOIN_Entries.sql
  6. CMS_06_Categories_LEFT_OUTER_JOIN_Entries.sql
  7. CMS_07_Categories_RIGHT_OUTER_JOIN_Entries.sql
  8. CMS_08_Categories_FULL_OUTER_JOIN_Entries.sql
  9. CMS_09_Left_outer_join_UNION_right_outer_join.sql
  10. CMS_10_CREATE_VIEW.sql
  11. CMS_11_Derived_tables.sql
  12. CMS_12_Date_comparisons.sql
  13. CMS_13_Correlated_subquery.sql
  14. CMS_14_Content_and_Comment_tables.sql
  15. CMS_15_Add_FK_to_entries.sql
  16. CMS_16_Supercategories.sql
  17. CMS_17_Entrykeywords.sql
• Discussion Forums
  1. Forums_01_Setup.sql
  2. Forums_02_Aggregate_functions.sql
  3. Forums_03_COUNT.sql
  4. Forums_04_Scalar_functions.sql
  5. Forums_05_Foreign_keys.sql
• Shopping Carts
  1. Cart_01_Comparison_operators.sql
  2. Cart_02_LIKE_and_BETWEEN.sql
  3. Cart_03_ORDER_BY_price.sql
  4. Cart_04_ANDs_and_ORs.sql
  5. Cart_05_WHERE_1=1_and_WHERE_1=0.sql
  6. Cart_06_IN_subquery.sql
  7. Cart_07_NOT_EXISTS_and_NOT_IN.sql
  8. Cart_08_LEFT_OUTER_JOIN_with_IS_NULL.sql
  9. Cart_09_Detail_rows.sql
  10. Cart_10_Group_rows.sql
  11. Cart_11_GROUP_BY_with_WHERE.sql
  12. Cart_12_GROUP_BY_with_HAVING.sql
  13. Cart_13_ORDER_BY_qty_DESC.sql
  14. Cart_14_ORDER_BY_total.sql
  15. Cart_15_ORDER_BY_with_NULLs_last.sql
  16. Cart_16_Details_and_Totals.sql
  17. Cart_17_Vendors.sql
• Other Examples
  1. examples of the various types of join (test_01_illustrated.sql)
  2. DECIMAL data type (test_02_DECIMAL.sql)
  3. FLOAT data type (test_03_FLOAT.sql)
  4. TIME datatype (test_04_SUM_times.sql)