loan_id coll_date coll_pay_mode 8007571771 APR-2022 CH 8007571771 FEB-2022 CH 8007571771 JAN-2022 CH 8007571771 MAR-2022 CH 8007571771 MAR-2022 CL 8007571771 M
I have the following dataframe: # A tibble: 8 x 5 Year Group Unit Profit Sales <dbl> <chr> <chr> <dbl> <dbl> 1 2021 One
I have the following table of orders for users like the following: CREATE TABLE orders ( order_id UUID, user_id UUID, date date,
I have a query that looks like this: SELECT ordDetails.OrderId FROM orders.OrderDetail ordDetails WHERE ordDetails.Class <> 'O' GROUP BY ordDetails.
I have a long format dataset of 100,000+ individuals, capturing clinic visits at 5 different time points (not chronological). I've included an example dataset b
I have event, cases and roads tables. I want to join these 3 tables but i have a problem because there is two different road_id which matched same firstpoint, l
after 4 days of tries and researchs over the web I can't make my wishes working. Any help would be appreciated !Performed on MYSQL WORKBENCH I got a DB made of
I’m having trouble on a query right now to retrieve only the last value saved for each group of results. I explain myself with a table. I have these value
Can someone help me with the below. I have an input dataframe. ID process_type STP_stagewise 1 loan_creation Manual 1 loan creation NSTP 1 reimbursement STP 2
Here is what I am trying to get done. Partly I am thru, Partly I am stuck, and need some help. Table structure: CREATE TABLE UserRole ( Id bigint NOT NULL A
I am trying to find percentage based on id column. issue - I am trying to use count(column)/select count(column) from table which is giving output as 'Zero' Tab
I want to do a rolling sum based on different levels of the index but am struggling to make it a reality. Instead of explaining the problem am giving below the
I have 3 tables structure like below:- products id name 1 apple 2 orange branches id name 1 Branch 1 2 Branch 2 stocks id branch_id product_id qty 1
I have a following data: I want o summarise the data in three columns by Subject type and other two columns sates number of schools and number of students by ea
I have a set of records in a db table like this. The thing that logically links these records is guid1 and guid2 but not all records in the table have a full re
I have a pandas dataframe indexed by createdAt grouped by pid (participant identifiers). The created at column are unix timestamps. Now I would like to add a ne
I have a table like Date Balance A Balance B --------------------------------- 2022.03.01 100 200 2022.03.01 200 500 2022.03.02 300
I have a dataframe: val1 val2 val3 a b 10 a b 2 b a 3 f k 5 f k 2 when i do df.groupby(["val1", "val
I am only working with two tables. One is a list of IDs (Accounts that i need to find the information on) I am looking up those ids in another table (purchases)
I have to write some simple queries for my database homework using SQLServer. The schema has been provided in the question: students(student_id, name); friends(