Simple SQL query over a OSCOmmerce database

Cerrado

Descripción

I need a SQL query that will return the customers who have done purchases over a given ammount (3000EUR) over a given period of time (last year).

We have an "orders" table. The table has the following fields (it has more, not related).

orders_id (int)

customers_name (varchar)

billing_company_tax_id (varchar)

date_purchased (datetime)

We have an "orders_total" table. The table has the following fields (it has more, not related).

orders_id(int)

title(varchar)

value(decimal 15,4)

I need to get a list of all the customers that have purchased over 3000E over year 2016. An SQL quert that can be run with PHPMYADMIN is enough.

Each customer has a unique value which is the "billing_company_tax_id". I need the orders for each "billing_company_tax_id" added, and shown only those that go over 3000EUR.

The "title" on "orders_status" must be "Total:", since each order has a few lines (subtotal, shipping cost, taxes, etc) and we only want to add the "Total" line on each order.

I might supply a sample database if needed.

Habilidades: MySQL, SQL

Ver más: create a sql database and create a simple but good looking website where i can access and query the database, input form query sql database, database error query error sql syntax check manual corresponds mysql server version syntax phplist_user_user line phplist, database error query error sql syntax check manual corresponds mysql server version syntax allnow, database error query error sql syntax check manual corresponds mysql server version syntax, sql query sql database size, import sql database oscommerce, sql database size query, query sql mobile database, access database sql simple project, oscommerce query database orders, oscommerce installation sql database, oscommerce query database, uusing data adaptor aspnet query sql server database, import csv file sql database oscommerce, need simple customer database, simple customer database

ID de proyecto: #12744460

Adjudicado a:

$14 USD en 1 día
(3 comentarios)
1.7

6 los freelancers están ofertando un promedio de $26 para este trabajo.

brendanmullan90

Hi there my name is Brendan and i am an expert in Web Development. PHP and SQL are two of my strongest languages and this is a job i can do for you. I can come up with the query you need and have a solution to your Más

$25 USD en 0 días
(9 comentarios)
4.1
$25 USD en 1 día
(5 comentarios)
1.9
kartickkoley1995

Greeting for you :-) Dear Client, We read your project brief ..After that I have Some queries in my mind about the project ..We need to discuss shortly if you allowing me, I will follow your instruction and complet Más

$35 USD en 1 día
(3 comentarios)
1.5
dennisthuranira

Hi am Dennis from Kenya surely i understand you need some specific queries done to the database. I can help you on this please be considerate thanks

$30 USD en 1 día
(0 comentarios)
0.0
hiberokpars

I can do SQl query for you, or PHP sript with same functions if you want Please conact me for details. I am professional developer with over 8 years of experience in web scraping. I do not do much business on this Más

$25 USD en 1 día
(0 comentarios)
0.0