I have created my first MySQL query to get the minimum LTP by MarketName/SelectionName. It works ok but I'm struggling to work out how to get the rest of the fields from the original table (checktable). I just want the…
I have the following table and i am supposed to count the entries(5,4,3,2,1) per column name ID ClientID Responsiveness1 Responsiveness2 Reliability1 1024 3511 5 4 3 1025 4571 5 3 5 1026 3827 4 5 4 1027 7652 1 1…
I have a table similar to the following. (The addresses are actually IP addresses, but I'm keeping them short for simplicity.) | Cust ID | Address | | ------- | --------| | 1 | 111 | | 1 | 222…
The following php script gives count of elements in a single xml file in the folder uploads. But I have number of xml files in the folder. What to modify in the following script so that I get result in…
As the subject states, I have a table with multiple rows per user and I need to get a count of all rows for each user with the data from the row with the oldest date AND then insert one…
enter image description here How to count notifications with a certain status and a certain user_id ? I have some data in notification table, how is the logic to calculate notification whose status is field 3 based on user_id 2…
I have three tables that describe data where there are some main things. Each thing can have several categories below it, and each category can have multiple segments. main main_id main_name 1 bla 2 blub categories cat_id main_id category_name 4…
I have this table that lists which months each product is available on the market. For example product 1 is available from Mar to Dec and product 2 is available from Jan to Feb. product_id start_month end_month 1 3 12…
I created SQL query which should count the number of e-mails sent after 20.12.2022 for each user_id from ACTIONQUEUE table. My query counts everything correctly for all users, but it doesn't returns 0 in the table for the users with…
I have table2 contains around 26 columns & 2mln rows. a b c d e f g h i j k l m n o p q r s t u v w x y z 18 2 2 22…