I need to converting a statement from MySQL to Postgres. The error is on this statement "INTERVAL $3 DAY". I am following a certain tutorial on building web apps using Go. MySQL - insrt:= INSERT INTO snippets (title, content, created,…
I'm converting my MyBB board to phpBB. The ONLY issue I'm having is that MyBB has quote tags like this: [quote="Username" pid="4993" dateline="1703638754"] But phpBB3 uses this: [quote="Username"] All I'd like to do is find any posts that contain the…
Note: Using Postgres I tried for hours and read many posts but still can not figure out how to make this query. I have two tables chat table id is_group_chat 1 false 2 false user_chat table (linked with user table)…
Here is the situation. Imagine a table with a few columns: ID Name Language ... 1 Bob ES ... 2 Bob EN ... 3 Bob DE ... 4 Bill EN ... 5 Jack EN ... 6 Jack DE ... 7…
I have a hotel reservations table with three columns: arrival date, departure date, and number of guests. I would like to create another table with two columns: date and total guest who are present in the hotel in this date.…
I have a deeply nested json array. The array contains a list of json objects, I want to remove any of the objects that are matched based on a field within the object. { "name": "John smith", "items": { "unknown-key-1":…
I have the next records from the table 'data' date_post date_complete 2023-11-28 2023-12-04 2023-11-28 2023-12-04 2023-11-28 2023-12-05 2023-11-28 2023-12-05 2023-11-29 2023-12-06 2023-11-29 2023-12-06 2023-11-29 2023-12-07 2023-11-29 2023-12-07 it's posible to select something like this? date_post date_complete 2023-11-28 2023-12-05 2023-11-28 2023-12-05…
Someone brought up a SQL challenge and I couldn't come up with a good solution to it. They wanted to see the best way to detect a split in a game of bowling. For some background, what I could find…
i am new to Laravel and i am working on a blog/post project with likes and comments. Now i would like to display/count all likes from all post that was made by a user. So for example: user 1 made…
This is a slightly more complicated reporting problem than I usually have. I want to find how many times customers have repurchased individual product listings. (Say, some products have really high sales, but we want to know how much are…