I've this query but it works only for DATE type. But my column type is DATETIME. How can I change this query to works on DATETIME type? I need to get output for todays report cases. SELECT COUNT(report_id) ASs total_today_case…
I'm taking a SQL class and I need help with a question. I have the following table on a phpmyadmin server patient (id, age) with a total of 100 patients I'm told to find the sum of people that have…
I have the calendar table with all the dates of the month of December 2021 (I will only exemplify some dates within the table, but it is understood that it actually contains all the days of said month): ID date…
After the last update of Mailster (email marketing plugin for wordpress), they have changed the way they store the information about opens, clicks, unsubscribes... Until now, everything was stored in two databases: bao_posts: Like any other wordpress post, the information…
I have a asp.net webforms application, where student can fill up a form and submit. The student information then gets saved to a database. There is a system to auto generate their academic roll number. To accomplish this task i…
I have two tables Users and Get_cal like below : Users id_user(pk) com 1004 700 1005 700 1006 700 1010 701 1011 701 1012 701 1013 701 1014 800 1015 800 1016 800 1017 800 Get_cal id_user(fk) status 1004 ABAN…
I have the following table called employees: num_employee name 001 George 002 Mary And the table called records: num_employee date 001 2021-12-01 002 2021-12-01 001 2021-12-02 002 2021-12-01 001 2021-12-03 002 2021-12-06 In the example above, both employees attended on…
I have table name wp_posts and in post_content column there is a description of my posts (in HTML). I would like to have a query that searches in post_content column and selects the tag starting with <div class or no…
I'm new to sql. I have 3 datasets , patient (columns : id age Zip_Code, size, weight, sex) blood_tests (columns : test_ID, test_date, blood_sugar, laboratory_ID, patient_ID) laboratory (columns : id, name, Zip_code, departments) how can i get the number of…
I have a request to get data in my mySQL database (36,848 entries). Then I format and append them with jQuery on my web page. These two operations take 2 minutes and 30 seconds. During this time, no other operation…