I am trying to get max(level) and sum(hours) until someone reaches level 5 for the first time. This is my input date level hours 1/1/2021 1 1 1/2/2021 2 1 1/3/2021 2 2 1/4/2021 3 1 1/5/2021 4 1 1/6/2021…
I want to merge json data distributed over multiple rows in a mysql column via python sqlalchemy library. I was planning to use json_merge_preserve but unable to use over an entire column. I used following code: select(func.json_merge_preserve(db.mytable.c.myjsoncolumn)) But it says…
right now im still practice sql. and try to solve challenge on hackkerank but i got some question and problem Here challenge that i take: "THE PADS" link : https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true This challenge contains counting the number of people based on…
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'm writing a script that needs to connect to a MySQL server via SSH. I have the following: import mysql.connector from sshtunnel import SSHTunnelForwarder def query_mysql_server(query): with SSHTunnelForwarder( ('ssh_server_ip', 22), ssh_username='sshuser', ssh_pkey='/Users/myhomedir/.ssh/id_rsa', ssh_private_key_password='my_ssh_key_passphrase', remote_bind_address=('127.0.0.1', 3306) ) as server: conn =…
I just installed MySQL on a fresh installation of Linux CentOS, but when mysql-server finished installing and I enter "systemctl start mysqld" it says: "Job for mysqld.service failed because the control process exited with error code." systemctl status mysqld.service -l…
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 used this, but it put the unit in a quote like 'MONTH'; how can I force him not to generate it without a quote? [DbFunction("TIMESTAMPDIFF", IsBuiltIn = true)] public static int DateDiffMinute([NotParameterized] string unit, DateTime start, DateTime end) {…
I wrote a SQL query that outputs a list of clan ids and their positions. SET @n := 0; SELECT id, @n := @n + 1 AS position FROM ( SELECT clans.id, SUM(clans_members.xp) AS xps FROM clans INNER JOIN clans_members…
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…