Online Free Tutorials Guruji Guide & Materials – Solved Questions Answers
I work in Python I have code that allows me to import a dataset that works fine. However in my dataset I have 3 different patients and I would like to import only the patient that interests me (…
I have datetime column and its values are like below 2021-04-13 15:31:59 2021-04-13 15:29:59 2021-04-12 15:31:59 2021-04-12 15:29:59 2021-04-10 15:31:59 2021-04-10 15:29:59 2021-04-8 15:31:59 2021-04-…
I have data like below mdate ————— 14 Apr 13 Apr 05 Oct 01 May 19 Jun But I am not getting any solutions how can I do that. And I need to order that data like …
I Have this table: [Messages table] I need to find the number of uniqe conversation – conversation is define as senderid sent msg to reciverid, and reciverid has replied (no matter how many times or …
Given table: +—+——-+——+—+ |id | attr | fker |did| +—+——-+——+—+ |1 | attr1 | 5 | 1| |2 | attr1 | 17 | 1| |3 | attr1 | 3 | 2| |4 | attr2 | 31 | 2| |5 | attr2 |…
I have a query that provides me with a list of productId:s that I then match with a products table.. But how would I adjust the query to give me only productId:s that are active (active=1)? My query: …
I’m trying to write a query that will only return a recordset between 2 positions in a table For example, using Excel to demonstrate, populate a recordset between positions 3 and 7 I thought about …
I would like to write the result of this SELECT to a permanent column, instead of a alias. Using MySQL. SELECT Machine_1_AccProduction, Machine_1_AccProduction – coalesce(lag(…
Could anyone help me understand why this query is not working? Modify the query to list all the products (product) and their associated category (product_category) if they have one. Otherwise, do not …
I am trying to select data entered for the past 5 years (to start from the 1st of Jan of the first or oldest year). I’ve constructed the query below but it does not begin from the 1st of January of …