amy | A web-based workshop administration application | Learning library

I'm trying to find admin activity within the last 30 days.

The accounts table stores the user data (username, password, etc.)

At the end of each day, if a user had logged in, it will create a new entry in the player_history table with their updated data. This is so we can track progress over time.

accounts table:

player_history table:

The following query

SELECT a.`username`, SEC_TO_TIME((MAX(h.`playtime`) - MIN(h.`playtime`))*60) as 'time' FROM `player_history` h, `accounts` a WHERE h.`created_at` > '2021-05-06' AND h.`user_id` = a.`id` AND a.`admin` > 0 GROUP BY h.`user_id`

Outputs this table:

Note that this is just admin activity, so Joe is not included in this data.

from 2021-05-06 to present (yy-mm-dd):

As you can see this from data, Amy's time is shown as 0 although she has played for 10 minutes in the last month. This is because she only has 1 entry starting from 2021-05-06 so there is no data to compare to. It is 0 because 10-10 = 0.

Another flaw is that it doesn't include all activity in the last month, basically only subtracts the highest value from the lowest.

So I tried fixing this by comparing the highest value after 2021-05-06 to their most previous login before the date. So I modified the query a bit:

SELECT a.`Username`, SEC_TO_TIME((MAX(h.`playtime`) - (SELECT MAX(`playtime`) FROM `player_history` WHERE a.`id` = `user_id` AND `created_at` < '2021-05-06'))*60) as 'Time' FROM `player_history` h, `accounts` a WHERE h.`created_at` >= '2021-05-06' AND h.`user_id` = a.`id` AND a.`admin` > 0 GROUP BY h.`user_id`

So now it will output:

But I feel like this whole query is quite inefficient. Is there a better way to do this?

I want to know how i can uniquely print out the elements of each list inside the dictionary without printing duplicates. Sorry i am quite new to programming. I am reading Python Crash Course 2nd edition and want to add a little bit of a challenge to my code.

I am trying to display images fetched from backend and I am able to display all the data except the images,

Below is the response which I got when I console.log the response,

Following are the files I have

1. Python wrapper
2. A simple terraform main.tf to spin up a ec2 instance
3. A variables.tfvars file

PYTHON WRAPPER

I have a df consisting of two different frames for each observation, denoted by the ending character in the variable

I am bit confused If any memory related issue happen when I declare classes like below by using Swift programming language, The main purpose is to reduce real-time compile process. Because my system goes very slow If I declare class globally that is using in only one class.

Hy guys, I have a sqlite database named signup.db and a signup table in it and I have a php code of a signup page but it us not inserting any data on submit I also am not getting Amy error even on clicking on submit *don't mind SQL injection this is just testing I will use SQL prepared statement when I make my next project Code

So, I have a dataset that looks like this:

I want to add a column that adds a factor variable of Red or Blue called "Winner_Colour".

I'm looking for a way for the code to look at the first letter of column 1 and 2, then look at Winner and create a new column "Winner_Colour" that has Red if the winner belongs to R_fighter or Blue if the winner belongs to B_fighter I have a feeling it might involve an if-statement and a ```mutate()`` function but I don't know where to start.