java-sql MVP - #1

Open

anthonyrende wants to merge 12 commits into

Commits on Sep 10, 2019

find all customers that live in London
anthonyrende
committed
38b0811
find all customers with postal code 1010
anthonyrende
committed
bdb917f
find the phone number for the supplier with the id 11
anthonyrende
committed
3243402
list orders descending by the order date
anthonyrende
committed
17c9657
find all suppliers who have names longer than 20 characters
anthonyrende
committed
0e1cf7c
find all customers that include the word 'MARKET' in the contact title
anthonyrende
committed
1382127
add a new customer record
anthonyrende
committed
6d2b21a
update _Bilbo Baggins_ record so that the postal code changes to 11122
anthonyrende
committed
70e71cb
list orders grouped by customer showing the number of orders per customer.
anthonyrende
committed
0107596
list customers names and the number of orders per customer. Sort the list by number of orders in descending order.
anthonyrende
committed
36590a1
list orders grouped by customer's city showing number of orders per city
anthonyrende
committed
4593c23
3NF database
anthonyrende
authored
eb22f49