I have a long list of names formatted like below. A person may have a few different representations of their name in the table (e.g. ‘Smith, Tom’ vs ‘Tom Smith’). A query will come through using a …
How to group data by year with paid and unpaid values
i have a MYSQL database where i want to sort the totals of both paind and unpaid amounts. The Query i used was : SELECT DISTINCT YEAR( app_payments.created_at ) AS YEARS, SUM( app_payments.amount ) …
Ignoring escape characters in python
I am trying to insert a title into a DB. Sometimes the title has quotes and it throws an error. I can’t replace quotes with a ” because it thinks that I am escaping the quote. sql = ‘UPDATE `…
How to access database on Android app without root
I’m developing a small app with a database of 100 elements. I import the database but only in one emulator (of 3 witch I have) runs correctly. I found that it runs without problems because the “Songs….
Fetch page data of specific OR other language
I have a table with webpage data that looks somewhat like this: row_id ⁞ page_id ⁞ lang ⁞ title ⁞ slug ────────┼─────────┼──────┼────────────────────┼──────────────── 1 ⁞1 ⁞……
Hive Most Popular in each group
I have three table BX-Books.csv ISBN, Book-Title, Book-Author, Year-Of-Publication, Publisher BX-Book-Ratings.csv User-ID ISBN Book-Rating BX-Users.csv User-ID Location Age I have to find most …
Joining player and game tables to get player points
I have the following SQL tables and I’m basically trying to pull a table of every game that Ralph played in for 2018, and the amount of points scored. Ralph has a unique_id, but may play on multiple …
How to link all tables together?
I need to list countries in which there are customers, the number of customers, the number of orders, and the total amount of money spent by customers from the country. Using w3school database, I …
SQL Server query JSONobject to get aggregated values
I have a JSON object stored in SQL Server, in a nvarchar(max) column. The JSON looks like this: { “data”: [{ “RespID”: 3512, “ObsPriceValue”: 2.34 }, { “RespID”: 4904, …
Migrate data from one table to the other
I have two tables and I have to transfer data from one to the other. Table 1: employees home_address string Table 2 emp_address address string emp_id int is_permanent bool I need to …