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

![schema screenshot](schema_screenshot.png)
![Site-Map](./schema_screenshot.png "Site Map")<commit_msg>work on getting image inline<commit_after>### 1.
SELECT * FROM states;
### 2.
SELECT * FROM regions;
### 3.
SELECT state_name,populations FROM states;
### 4.
SELECT state_name,population FROM states..
ORDER BY population DESC;
### 5.SELECT state_name FROM states
###   WHERE region_id=7;
### 6.SELECT state_name,population_density FROM states
###   WHERE population_density>=50
###   ORDER BY population_density ASC;
### 7.SELECT state_name FROM states
###   WHERE population BETWEEN 1000000 AND 1500000;
### 8.SELECT state_name,region_id FROM states
###   ORDER BY region_id ASC;
### 9.SELECT region_name FROM regions
###   WHERE region_name LIKE '%Central';
### 10. SELECT regions.region_name,states.state_name
###     FROM states
###     INNER JOIN regions
###     ON states.region_id=regions.id
###     ORDER BY regions.id;

![schema screenshot](schema_screenshot.png)
![Site-Map](schema_screenshot.png "Site Map")
{'fraction_non_alphanumeric': 0.13165112452002195, 'fraction_numerical': 0.030718595721338452, 'mean_word_length': 4.864951768488746, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 5, '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': '7374731', 'n_tokens_mistral': 614, 'n_tokens_neox': 533, 'n_words': 169}