I need to get list of transactions with list of logs and tags inside each transaction and the most important make search by field in logs and tags and unite it all. Example below is search by field1 and tag1.…
I want the solution like each item id all messages between sender and receiver and need all rows belongs to user i.e. if sender id = 3 and receiver id = 25 then it will list out all message of…
I am currently migrating some media assets to a 3rd party application (3PA), our internal system has the assets logged in the sample data below, however the 3PA requires the SoundRecordingCode be related to the ISRC so I need to…
The following SQL works well; it gives me the result I want for the counts and percentage: (please use EXTRACT (YEAR|MONTH|DAY ...) where required): SELECT YEAR(evt_date) AS yr, MONTH(evt_date) AS mth, DAY(evt_date) AS dy, COUNT(*) AS cnt, ROUND(COUNT(*)*100 / (SUM(COUNT(*))…
I have four tables: supplies, stocks, stock_ins, and stock_outs. In the Stock controller, I want to sum the total stock_out for each supply . For this, I have used the following query: $supplies = Stock::select( 'supplies.name', 'stocks.supply_id', 'stocks.id', 'stocks.stock', 'stock_ins.quantity…
A fun little MySQL puzzle! Given the dataset id Description Amount Category 1 Food #1 1 1 2 Non-food #2 bla 3 2 3 Food banana 5 1 4 Non-food #2 foo 1 2 5 Non-food #2 foo bar 3…
I would like to sum my day to day values into full months values This is the current table: Date Value 2024-01-01 12 2024-01-02 10 2024-01-03 20 2024-01-04 5 2024-02-01 15 2024-02-02 20 2024-02-03 10 I would like to create…
I am working on a Laravel app that needs to do a groupBy on a set of items like groupBy does on a collection however doing this on collection after getting the data will not work as I need to…
I am currently working on a project where a wordcloud is created for the NYT. Therefore I am scraping all the articles from the NYT from their API, and then store dates of the article, the articles href and all…
I have SQL table such as this: TABLE1 STUDENT SCORE SCOREVAL 1 PASS 10 1 MOD1 4 1 MOD2 5 2 MOD1 4 3 MOD2 2 3 MOD2 1 3 MOD1 9 3 ER 1 4 MOD2 10 4 ER…