These use the COUNT function and when I am trying to input “something” As… i get a cartesian note and/or no results show up. Could I have some help on this?
There are a number of problems you might be having. One could be that your tables are joined improperly or perhaps there is something wrong with your “Group By” line. Whenever using a function such as count or average, make sure to group by everything in your select statement except for the attribute you are performing the function on. I would recommend visiting the TA lab for more specific help.