select * from reviews_by_rating WHERE reviewoverallrating=3 AND restaurantid=2;
----------------------------------------------------------------
 reviewoverallrating  | 3
 restaurantid         | 2
 reviewdate           | 2019-08-01
 reviewid             | f930d8a0-152e-4fed-920e-ef5e8face5e3
 reviewambiencerating | 5
 reviewbody           | I LOVE THIS PLACE!
 reviewfoodrating     | 5
 reviewhelpfulcount   | 15
 reviewnoise          | 4
 reviewrecommend      | True
 reviewservicerating  | 5
 reviewvaluerating    | 1
 userlocation         | san francisco
 username             | JOEBERTHOUD
 usertotalreviews     | 5







 select * from restaurant_reviews WHERE restaurantid = 2;

@ Row 1
----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 restaurantid         | 2
 reviewdate           | 2019-07-29
 username             | SavannaWatsica
 reviewid             | fba531b6-1484-46d4-bd4b-f3c8fd0e149c
 reviewambiencerating | 3
 reviewbody           | Quo molestiae ea dolorem nobis aperiam id incidunt voluptas dolorem. Eos recusandae maxime consectetur ipsa qui reiciendis odio. Non fugiat repellat totam non non. Voluptate quos assumenda sapiente laudantium architecto.
 reviewfoodrating     | 5
 reviewhelpfulcount   | 11
 reviewnoise          | 1
 reviewoverallrating  | 3
 reviewrecommend      | True
 reviewservicerating  | 1
 reviewvaluerating    | 1
 userlocation         | HELLLL
 usertotalreviews     | 11

@ Row 2
----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 restaurantid         | 2
 reviewdate           | 2019-08-01
 username             | JOEBERTHOUD
 reviewid             | f930d8a0-152e-4fed-920e-ef5e8face5e3
 reviewambiencerating | 5
 reviewbody           | I LOVE THIS PLACE!
 reviewfoodrating     | 5
 reviewhelpfulcount   | 15
 reviewnoise          | 4
 reviewoverallrating  | 3
 reviewrecommend      | True
 reviewservicerating  | 5
 reviewvaluerating    | 1
 userlocation         | san francisco
 usertotalreviews     | 5



 UPDATE reviews_by_rating SET userlocation='SAN CODELAND' WHERE reviewoverallrating=3 AND restaurantid=2 AND reviewdate='2019-08-01' AND reviewid=f930d8a0-152e-4fed-920e-ef5e8face5e3;

 ----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 reviewoverallrating  | 3
 restaurantid         | 2
 reviewdate           | 2019-08-01
 reviewid             | f930d8a0-152e-4fed-920e-ef5e8face5e3
 reviewambiencerating | 5
 reviewbody           | I LOVE THIS PLACE!
 reviewfoodrating     | 5
 reviewhelpfulcount   | 15
 reviewnoise          | 4
 reviewrecommend      | True
 reviewservicerating  | 5
 reviewvaluerating    | 1
 userlocation         | SAN CODELAND
 username             | JOEBERTHOUD
 usertotalreviews     | 5



 INSERT INTO restaurant_reviews (
                   ...     restaurantid,reviewdate,username,reviewambiencerating,reviewbody,reviewfoodrating,reviewhelpfulcount,reviewid,reviewnoise,reviewoverallrating,reviewrecommend,reviewservicerating,reviewvaluerating,userlocation,usertotalreviews) VALUES (3,'2019-07-28','julioFuentes',5,'place is good',4,20,8af8d970-990b-4866-9b88-6dafa8d4e204,3,3,False,4,3,'san jose',20);


 ----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 restaurantid         | 3
 reviewdate           | 2019-07-28
 username             | julioFuentes
 reviewid             | 8af8d970-990b-4866-9b88-6dafa8d4e204
 reviewambiencerating | 5
 reviewbody           | place is good
 reviewfoodrating     | 4
 reviewhelpfulcount   | 20
 reviewnoise          | 3
 reviewoverallrating  | 3
 reviewrecommend      | False
 reviewservicerating  | 4
 reviewvaluerating    | 3
 userlocation         | san jose
 usertotalreviews     | 20