Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
pp:project2021 [2022/05/11 12:02] vbadoiu [3.6 Typos (1p)] |
pp:project2021 [2022/05/11 18:45] (current) dmihai [3.6 Typos (1p)] |
||
|---|---|---|---|
| Line 402: | Line 402: | ||
| Your job is to fix the typos in ''email_map'' table, generate the correct table and then use that to join the information about user’s stats. | Your job is to fix the typos in ''email_map'' table, generate the correct table and then use that to join the information about user’s stats. | ||
| - | ==== 3.6 Typos (1p) ==== | + | ==== 3.6 Typos (0.4p) ==== |
| Column ''Name'' from table ''email_map'' contains typos. Example: //Zane Kayle// is misspelled as //Zan Kayle// or //Amelia Caden// is misspelled as //Amelia Camdden//. Fortunately, the name //Zane Kayle// contains only a few misspelled letters and it is guaranteed to appear in the correct form, in the name column of the ''8h sleep'' or ''physical_activity_in_a_day'' tables. Hence, we can use the latter names as **reference** to correct the typos. | Column ''Name'' from table ''email_map'' contains typos. Example: //Zane Kayle// is misspelled as //Zan Kayle// or //Amelia Caden// is misspelled as //Amelia Camdden//. Fortunately, the name //Zane Kayle// contains only a few misspelled letters and it is guaranteed to appear in the correct form, in the name column of the ''8h sleep'' or ''physical_activity_in_a_day'' tables. Hence, we can use the latter names as **reference** to correct the typos. | ||