<commit_before>Query 1: SELECT * FROM states; 
Query 2: SELECT * FROM regions;
Query 3: SELECT state_name, population FROM states;
Query 4: SELECT state_name, population FROM states ORDER BY population DESC;
Query 5: SELECT state_name FROM states WHERE region_id=7;
Query 6: SELECT state_name, population_density FROM states WHERE population_density > 50 ORDER BY population_density;
Query 7: SELECT state_name FROM states WHERE population > 1000000 AND population < 1500000;
Query 8: SELECT state_name, region_id FROM states ORDER BY region_id;
Query 9: SELECT region_name FROM regions WHERE region_name LIKE "%central%";
Query 10: SELECT regions.region_name, states.state_name FROM states INNER JOIN regions ON states.region_id=regions.id
   ...> ORDER BY regions.id;  


My Outfit/Person Schema:  
![Schema](schema.png)  

## Reflection  
  
* What are databases for?    
	Databases are great at organizing information in a usable format. They make it possible to store, organize, edit, or add information easily. 

* What is a one-to-many relationship?  
  A one to many relationship is when one table (or piece of information) is repeated in another table. In my outfit schema, for example, each outfit would only be owned by one person, but each person could own several outfits. The person ID would be repeated several times in the outfit table. 

* What is a primary key? What is a foreign key? How can you determine which is which?  
	A primary key is a column of data in a table that is unique for each row. It is used to reference it from other tables. If there were duplicates, the related tables wouldn't know which record was being referenced. A foreign key is one that references the primary key of another table. Using my outfit schema again, the person ID has a primary key of ID, and then the person_id column in the outfits table refers to the person. In the schema designer, the primary key is bolded to make it easy to find. Another good hint is to look for which values are unique and not repeated. <commit_msg>Fix query formatting<commit_after>* Query 1: SELECT * FROM states; 
* Query 2: SELECT * FROM regions;
* Query 3: SELECT state_name, population FROM states;
* Query 4: SELECT state_name, population FROM states ORDER BY population DESC;
* Query 5: SELECT state_name FROM states WHERE region_id=7;
* Query 6: SELECT state_name, population_density FROM states WHERE population_density > 50 ORDER BY population_density;
* Query 7: SELECT state_name FROM states WHERE population > 1000000 AND population < 1500000;
* Query 8: SELECT state_name, region_id FROM states ORDER BY region_id;
* Query 9: SELECT region_name FROM regions WHERE region_name LIKE "%central%";
* Query 10: SELECT regions.region_name, states.state_name FROM states INNER JOIN regions ON states.region_id=regions.id
   ...> ORDER BY regions.id;  


My Outfit/Person Schema:  
![Schema](schema.png)  

## Reflection  
  
* What are databases for?    
	Databases are great at organizing information in a usable format. They make it possible to store, organize, edit, or add information easily. 

* What is a one-to-many relationship?  
  A one to many relationship is when one table (or piece of information) is repeated in another table. In my outfit schema, for example, each outfit would only be owned by one person, but each person could own several outfits. The person ID would be repeated several times in the outfit table. 

* What is a primary key? What is a foreign key? How can you determine which is which?  
	A primary key is a column of data in a table that is unique for each row. It is used to reference it from other tables. If there were duplicates, the related tables wouldn't know which record was being referenced. A foreign key is one that references the primary key of another table. Using my outfit schema again, the person ID has a primary key of ID, and then the person_id column in the outfits table refers to the person. In the schema designer, the primary key is bolded to make it easy to find. Another good hint is to look for which values are unique and not repeated. 
{'fraction_non_alphanumeric': 0.047886635719521134, 'fraction_numerical': 0.013681895919863182, 'mean_word_length': 4.3237971391417425, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 9, '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': '508212', 'n_tokens_mistral': 1117, 'n_tokens_neox': 999, 'n_words': 623}