I'm working on MySQL workbench 8.0 and I would like to find the number of types of buyers for each product per user_id. For instance, for chairs, if user_id 1, user_id 2, and user_id 3 make purchases only once, I…
I have two tables; bookings and tasks. Each booking has 1-to-many tasks. bookings table: +--------------+----------------+------+-----+----------------+ | Field | Type | Null | Key | Extra | +--------------+----------------+------+-----+----------------+ | bookingsID | int(8) | NO | PRI | auto_increment | | clientID…
I have the following rows: id status startdate enddate 111 0 2023-01-13 2023-01-17 111 1 2023-01-18 2023-01-22 111 1 2023-01-23 2023-01-23 111 1 2023-01-24 2023-01-26 111 0 2023-01-27 9999-12-31 222 0 2023-01-19 2023-01-22 222 0 2023-01-23 2023-01-27 222 0 2023-01-28…
Can anyone help me whats wrong with my code SELECT agent.agent_name AS agent_name, (SELECT COUNT(assigned.id_agent))AS itung, (SELECT COUNT(ticket.id_agent) WHERE ticket.id_status = 4) AS itung2 FROM agent LEFT JOIN assigned ON agent.id = assigned.id_agent LEFT JOIN ticket ON agent.id = ticket.id_agent…
I have two tablse with different structure: contents folders I need getting data from two tables with pagination, sorting and filter. I know only about this way like getting two tables in 2 operations. Is it possible union these tables…
I want to truncate tables where the value of my column isTrun in the config table is True. The scripts need to run in the Sink pre-copy script of the copy activity. The dataflow is the following: The look-up activity…
Suppose I have a table with column position and 10 rows with values: [1, 2, 3, 1, 1, 1, 2, 4, 3, 2]. How do I select * from that table with only 1 row for each position? I use…
Table 1 |Part| Date | Price | |A | 1-May-2021 |10 | |B | 1-June-2021 |20 | Table 2 |Part| Date | Quantity | |A | 15-May-2021 |4 | |B | 25-June-2021 |5 | Need Output as below |Part| Date…
In a PostgreSQL have the table Sales containing the following data: | id(PK) | eva_dts_id(FK) | realm_name | device_id | timestamp | product_id | product_name | quantity | product_price | revenue | realm_name and device_id are constants and even if…
The code below is not compiling by HeidiSQL in a MYSQL base BEGIN if NOT EXISTS (SELECT * FROM pedido_itens WHERE ID_PEDIDO = OLD.ID_pedido) DELETE from pedido WHERE pedido.ID = pedido_itens.old.ID_PEDIDO; END if; END I'm trying to create a trigger…