sammy | A bare-bones PHP version of the Ruby Sinatra framework | Command Line Interface library

I am a newbie so please be kind, working on a blog app within my django project the idea is to check if there are articles , if there is list each article. if there is not articles show no articles found

below is my view function, however when I test this it only list the first item in my list which mike, other names are not showing on the page or on source like they do not exist ??? any help with this would be great. thanks in advance

So I am trying to get my dictionary of lists to match up with my list of tuples. (hopefully that makes sense). I have a dictionary with lists as the values, my values are individual scores for each book, ex: the value 5 on bob would equal the first book in the book list, :

I have a simple filter().map() function:

My goal is it to let my DataGrid look like Picture2. So I created two DataGrids to realize this because i didnt find a better way to do this, but the solution is not very clean and I run into more and more problems. So in the first DataGrid I have the heading normal and in the second I have textBoxes in the heading that should act as a search bar. It looks like this with 2 DataGrid:

Because my goal is that my DataGrid will look like this in the end:

The problem now is that when I click on the first header, my data cannot be sorted in ascending or descending order. This only works if I click the second header on the second datagrid. But the button for sorting in ascending or descending order should not be in the second header, but in the first header. The best thing would be to use a DataGrid for this, but I don't know how to implement it so that the headings are in the first header and when I click in the first header that everything is sorted in ascending or descending order. And with the second header directly below then the TextBoxes that should serve as a search bar and below then the values. How do I manage that when I want to cut everything into a DataGrid. First of all, here is my code:

So I have 2 DataGrids (because I haven't found a better way to do it the way I want it) and I have the following code in the .cs:

I'm creating a database that keeps track of books, users, and what books each user owns. A user can have several copies of a certain book, specified by their book id. What I'm trying to calculate in particular is show for each username the number of all books they own and the number of non-duplicated books they own. I have an attempt below but the numbers do not appear to be correct. For example after doing my select statement, it says that Sammy's total number of duplicated books is 4 and his total number of non-duplicated books is 3.

When you actually look at the data in the owns table, you can see the real values are that Sammy's total duplicated books is 3+2+1+1 = 7 books, and his total number of non-duplicated books would just be the total number of unique book_ids he has in his collection which is just 4.

I'm not sure what's wrong with the logic of my query and would appreciate some help.

Schema:

The number of np.where()'s I would assume is the issue since removing 1 will allow the function to work. I'm not aware of another way to edit a name other than an if else. I figured this would be faster. Mapping comes to mind as well, but I'm not sure how to return the names that are not changed. Any help understanding the best practice for this desired outcome would be very much appreciated!

I wrote this code to compute student quiz scores and I got this part to work.

The user (Ben) has joined group 2 and group 3. How can I write this in a select query... I want to select from groups I haven't joined and groups I didn't create.