kjell | Shell window '' base environment built on Zifro Playground UI

"Select the beers that have been drank by more than one person". Basically, I'm trying to retrieve a query result that shows me the list of the beers that has been drank by more than one person and then the name of the persons who have drank that beer. I tried to do a group and having clause but realized that I cant have a group clause since I'm interested in duplicate values from both the name and beer columns. What should I do?

The aim is to select all the names of the persons who have drank all beers from tyskland. In this case, im looking to find the name of the person that has max(count) of beers from germany. I formed smaller tables along the way to try to get the result: From the table below :

How does one select a certain column whose got values of same value in another column? In this case, the aim is to select the names of the people who teach in the same class. So how does one select the names of the peple who teach in the same class?

Ive been looking around different sites and havent found any examples om how to join different tables when looking for a result while including a except statement in the query. To know the structure of such a query would be very helpful! Lets say I want to find the names of the people who havent drank the beer Anchor Steam Beer, how should the query operation look like?

My own attempt looked like this:

I'm trying to order a table by a column (Tavling) where GROUP_CONCAT has been applied, however I can't seem to order the list so that it goes top to bottom starting with the row that contains the most results from the GROUP_CONCAT function.

So in this case it should start with the row that contains 3 results from the GROUP_CONCAT function, then the rows that contains 2 results, then the 2 rows that contains one result and the at last the null value.

Desired result:

I'd like to know how to find the names (namn) of the people who have taught on a course (kkod) but have never been course coordinator (kansv). Is it a minus operation (not exists operation)? The result should look like:

Im trying to find the person who has drank most beer types from USA. The result should be just be the name of that person alone and not include a count column. How should I perform the select statement? The result should look like this:

I'm trying to find the courses (knamn) that only Lennart have taught in but not Alan or Kjell.

The result should look like this:

Basically I want to select the rums that appear more than once but with its teachers (namn) having different telephone values (tel) ( thatd be rooms altair, kompis, and mulitplan). How do I select the rows so that it becomes;