Hi I’m on SQL Summary Stats but my answers didn’t seem to get accepted. The results looked correct to me but the system said ‘The value for result doesn’t look right’. Could you help take a look?
For example, in step 2 I got 40000 as output and my code is "SELECT min(Median) FROM recent_grads WHERE Major_category = ‘Engineering’ ".
Also, how can i get a list of column names? I found ‘PRAGMA table_info(recent_grads)’ but it returns more details than I wanted. What if I just want the column names, ie, ‘index’, ‘Rank’, ‘Major_code’, etc?
Thanks a lot!