The challenge was to use MYSQL and create a database for a shop and 4 tables (Category, Subcategory, Products and sales) and then create SQL query code to search the tables. FOr example "find the most popular product for a specific day".

My personal challenge was very much trying to create and understand the more complax search queries.

My expecatations were low! I have understood SQL when brokedn into smaller chunks and understand how the "logical thinking" part of it works as well as being able to follow along during the class, All makes sense however as soon as it comes to putting this into practice and being able to write the raw code from scratch i find it difficult to implement that learning and understanding. As a result i am expecting to really rely on others in the team to help me get working code and then work from there to make small changes in order to fit my tables and test the code as well as understand it.

The group/teamwork was the best and most succesful part of the challenge. As i expected i could create tables and databases easily and run general simply queries on my tables. I was only able to get as far as i did with the help and collaboration of the team.

The more complicated queries (inner queries and searching through multiple different tables) to get a result i needed was by far the hardest part of the challenge. I know with practice this will become second nature but as it stands i can only get so far in terms if complexity before i loose focus and cant go further

I need to practice working backwards when writing my queries. I found a tendancy to start for example on the most outer query whereas logic dictates to work backwards from the inner queries to the outer queries. I also need to practice more on creating more complex queries whlist trying to use more than one table.