I recently gave test on codility platform and was stuck on below SQL question. Question: For an online platform assessments were conducted for 3 topics and scores were provided. Table: Assessments Input: |Id|experience|sql|algo|bug_fixing| |1 |5 |100|null|100 | |2 |1 |100|100…
The section fronts on a Wordpress site I help out with have just started loading slow, and I traced it to the SQL query that loads the posts for the page, and timed a few different queries to see what's…
I have a table that looks like this Tep ID number Date Value type ABC 1 22-09-2021 1.2 X XYZ 2 22-10-2021 3.2 X ABC 3 22-10-2021 3.2 Y WSH 4 22-10-2021 3.2 X I want the output like this…
I have a Database Schema like this. I am working on gettingDetailByPostID API which needs to return 1 Object as follows. Guid PostId; Guid UserId; String? Username; String? MediaPath; int Likes; // count the number of likes of the post…
The request of my function has a problem: function rdvDelete($rdv) { $pdo = connexion(); $sql = $pdo->prepare("DELETE FROM visitors,rdvs WHERE rdvs.idRdv = :rdv AND visitors.idVisitor = rdvs.idVisitor"); <-- line 34 $sql->execute(['rdv' => $rdv]); } $rdv = 3 !!! And this…
I'm having problems with a slow SQL query running on the following system: Operating system: Debian 11 (bullseye) Database: MariaDB 10.5.15 (the version packaged for bullseye) The table schemas and some sample data (no DB Fiddle as it doesn't support…
I have my table like this: event_date user_id 2021-10-01 1 2021-10-01 2 2021-10-02 1 2021-10-02 2 2021-10-02 3 2021-10-03 3 2021-10-03 4 2021-10-03 4 2021-10-04 5 2021-10-04 2 2021-10-06 3 2021-10-06 5 Sample data WITH my_table (event_date, user_id) AS (…
I haven't written a stored procedure as yet. I have just deserialised some JSON data from a Web API feed. I've got some console writelines to confirm the data is being deserialised, but need to replace them with writing stored…
I created a table using the following SQL command: CREATE TABLE [my-azure-db].dbo.MyTable ( Id int IDENTITY(1,1) NOT NULL, Name nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, ); When I check the table with DBeaver, it looks like this: Therefore, I tried to…
I am trying to generate a selection of table columns which is proving difficult - I am using phpmyadmin tool I have a Players table and I have a teams table - My objective is to display each team in…