I want to report a missmatch between movies and database delivered to course.
It happen before, but I skipped to inform anybody. When it happen second time I wanna raport this, becaues somebody can get stuck.
I am not able to add screenshot, because I am new user so here is piece of script delivered to learn the course:
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; INSERT INTO `customers` VALUES (1,'Babara','MacCaffrey','1986-03-28','781-932-9754','0 Sage Terrace','Waltham','MA',2273); INSERT INTO `customers` VALUES (2,'Ines','Brushfield','1986-04-13','804-427-9456','14187 Commercial Trail','Hampton','VA',947);
As You can see there is only one user from Virginia and in the movie HAVING Clausule you can see that after:
SELECT * from customers WHERE state = 'VA'
two results appear with ID 1 and 2 which is not true with this script.