/week-10-day-3

Evaluation of rework, for week 10 day 3: SQL-lite

Primary LanguageJavaScript

repo instructions for week 10 day 3

echo "# week-10-day-3" >> README.md git init git add README.md git commit -m "first commit" git branch -M main git remote add origin https://github.com/nathanieldcooke/week-10-day-3.git git push -u origin main

Intro to Databases

no bugs/errors found

SQL Database Schema

no bug/errors found

CREATE/DROP Tables

no bug/errors found

INSERT Data

no bug/errors found

SELECT Data

no bug/errors found

DELETE Data

no bug/errors found

UPDATE Data

no bug/errors found

Reading .sql Files

no bug/errors found

Intro to SQL and Express

no bug/errors found

Basic SQL

Phase 1

no bug/errors found


Phase 2 

no bug/erros found

Phase 3

Ross demands a refund for the last two coffees that he ordered. (Make sure you delete Ross's coffee orders and not anyone else's. Update his points to reflect the returned purchases.)

    How can I delete his orders without a foreign_key linking a coffee order to his?.. with manually backtracking every order made since then?


Phase 4

Proof read... but... Nahhh, not doing all that. 
I do like the theme lol

HomeWork Notes:

should it be === equalt for : https://raw.githubusercontent.com/appacademy/Modular-Curriculum/master/content/module-04/[…]iz-select-clauses.md?token=AD6HJ6VS6M4YVIIGDSMP2ADBTZK7M

10 = 6 is not equal to 6 months. link: https://github.com/appacademy/Modular-Curriculum/blob/master/content/module-04/wee[…]intermediate-sql/readings/reading-select-using-sql-operators.md