<commit_before>## U3.W7: SQLZoo

####I worked on this challenge [by myself, with: ].



### My Quiz Results:
<!-- Include the link to your image (saved in the imgs folder) to display it inline. -->






### Reflection

What parts of your strategy worked? What problems did you face?

Dealing with the bug to create an account in SQL zoo ended up taking longer for me than doing the exercises.  Once I got up and running, it became easier.  

What questions did you have while coding? What resources did you find to help you answer them?

I took a pretty straightforward approach of googling the command, space, followed by sql every time i encountered an unfamiliar topic.  

What concepts are you having trouble with, or did you just figure something out?
I'm pretty comfortable with select in select, aggregation, and joins; but having trouble combining the concepts as the commands get more complicated.  

Did you learn any new skills or tricks?
the select command syntax was very straightforward to follow.  I'm very happy to learn many ways to manipulate databases.

How confident are you with each of the Learning Competencies?
Not extremely confident.  With limited time during the last 2 weeks, I'm struggling to get through the curriculum and sometimes skipping the bonuses. 

Which parts of the challenge did you enjoy?
Enjoyed learning ins and outs of sql

Which parts of the challenge did you find tedious?
Set up and looking through multiple online sources.  Wish program had something I can look at locally in my desktop, regardless of whether wifi/internet connection was available.<commit_msg>quizzes<commit_after>## U3.W7: SQLZoo

####I worked on this challenge [by myself, with: ].



### My Quiz Results:
<!-- Include the link to your image (saved in the imgs folder) to display it inline. -->
<img src="../imgs/sqlzoo_quiz.jpg" />




### Reflection

What parts of your strategy worked? What problems did you face?

Dealing with the bug to create an account in SQL zoo ended up taking longer for me than doing the exercises.  Once I got up and running, it became easier.  

What questions did you have while coding? What resources did you find to help you answer them?

I took a pretty straightforward approach of googling the command, space, followed by sql every time i encountered an unfamiliar topic.  

What concepts are you having trouble with, or did you just figure something out?
I'm pretty comfortable with select in select, aggregation, and joins; but having trouble combining the concepts as the commands get more complicated.  

Did you learn any new skills or tricks?
the select command syntax was very straightforward to follow.  I'm very happy to learn many ways to manipulate databases.

How confident are you with each of the Learning Competencies?
Not extremely confident.  With limited time during the last 2 weeks, I'm struggling to get through the curriculum and sometimes skipping the bonuses. 

Which parts of the challenge did you enjoy?
Enjoyed learning ins and outs of sql

Which parts of the challenge did you find tedious?
Set up and looking through multiple online sources.  Wish program had something I can look at locally in my desktop, regardless of whether wifi/internet connection was available.
{'fraction_non_alphanumeric': 0.043357933579335796, 'fraction_numerical': 0.0018450184501845018, 'mean_word_length': 4.2131410256410255, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '218866', 'n_tokens_mistral': 796, 'n_tokens_neox': 750, 'n_words': 513}