Unknown gender column in the field
I have been following your tutorials one by one, but why don't I get the same result as you do? For someone who doesn't know anything about SQL, this is quite confusing. i don't know where i got it wrong, even after following it diligently. 
3 answers ( 0 marked as helpful)
Hi Aina!
Thanks for reaching out.
You forgot to add the gender column in the customers table. This is why Workbench does not find this column.
Hope this helps.
Best,
Tsvetelin
how can we add the gender column?
To answer Hassan,
Here is the querry to add gender column:
ALTER TABLE customers
ADD COLUMN gender ENUM('M', 'F') AFTER last_name;
Submit an answer
