I have a list of posts: [{"name: "POST 1", {"name": "POST 2",}, {"name": "POST 1",} I want to count the number of identical names and output the maximum number. The expected result is: {"id: "POST 1", count:2} Now I wrote…
Hello I had an sql getting the number of orders this week. My sample query below: SELECT products.name, (SELECT COUNT(orders.product_id) FROM orders WHERE orders.product_id = products.id AND DATE(orders.order_date) >= [from] AND DATE(orders.order_date) [to]) as total_orders FROM products p; Now I…
I have a color table t1 with data like below, sorted by sn select * from t1 order by sn +---+-------+ |sn |color | +---+-------+ |25 |Brown | |29 |Brown | |33 |Blue | |37 |Red | |42 |Green |…
I have a table in Postgres with an hstore column like: "surface => concrete, ramp => yes, incline => up, highway => footway" "surface => asphalt, lit => no, source => survey, incline => 12.6%, highway => footway" "bicycle =>…
Is there available SQL (MySQL/PostgreSQL/SQL Server etc.) Docker container with records? I know there are SQL containers on docker hub, but those are "empty" databases. I'm looking for a container where already installed schemas, tables etc and those tables are…
My solution: $author_id = 25; $sql = "SELECT DISTINCT author_id AS label FROM users WHERE author_id ::text LIKE '%:term%' AND role = 'Editor'"; $query = Users::findbysql($sql, [ ':term' => $author_id ] )->all(); The problem is the label alias, which then…
I have the following tables: Table 1: Number PK Word PK 1 A 1 B 1 C 2 B 2 A 2 C 3 J 3 K 3 B Table 2: Number2 Word2 1 A 2 X 3 B I…
I have a database with email and phone columns. One email can have several phones, which results in multiple rows with same email but different phone numbers. I want to query all emails with it's phones grouped in one single…
I have a table with these columns: id (int) col1 (int) col2 (varchar) date1 (date) col3 (int) cumulative_col3 (int) and about 750k rows. I want to update the cumulative_col3 with the sum of col3 of same col1, col2 and previous…
I am working with a booking appointment system. I want to find out how many time slots are available and how many time slots are already booked. time slot count will be change base on the appointment. I used laravel…