En curso

Simple SQL query over a OSCOmmerce database

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).



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: import sql database oscommerce, sql database size query, query sql mobile database, oscommerce query database orders, oscommerce installation sql database, oscommerce query database, need simple customer database, simple customer database

Información del empleador:
( 12 comentarios ) Barcelona, Spain

ID de proyecto: #12744460

Adjudicado a:

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

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


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)
$25 USD en 1 día
(5 comentarios)

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)

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)

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)