Devam Ediyor

505238 need help with some mysql queries

I'm writing some mysql queries for a reporting application and need some help in creating five different main queries.

It may be a combination of mysql with php to get the exact results.

I have a table with one transaction per row ... it includes user_id, transaction id, date, product (and other fields which are unrelated)

The queries I need to create are:

(1) how many results for a particular month for new users (i.e. this is the first occurrence of that user_id)

(2) how many results for a particular month where there was no transaction for a user_id that, no transactions in the next two months, but there was in a previous month

(3) how many transactions for a particular month where the user has a transaction this month and the product ID for the current month is a "higher level" we have a separate table to determine levels) than in previous months

(4) how many transactions for a particular month where the user has a transaction this month and the product ID for the current month is a "lower level" than previous months

(5) how many transactions for a particular month where the user has a transaction this month, did not have one the previous two months, but has one at the same level prior to that 3 months ago.

Beceriler: Her şey Kabul, Makale Yeniden Yazım, MySQL, PHP

Daha fazlasını görün: need help in writing, i need help with writing, help with writing, help with php, create application with php, queries, need help with writing, m&a transactions, table queries, mysql help table, mysql create table fields, help creating, article particular product, mysql reporting, need help product, help current, mysql level, need help article writing, rewriting application, need help article, php mysql reporting, current date mysql, mysql row, mysql reporting php, mysql date table

İşveren Hakkında:
( 104 değerlendirme ) Mebane, United States

Proje NO: #2251162

Seçilen:

dustafo

I can get this done for you pretty quickly.

0 gün içinde 75$ USD
(157 Değerlendirme)
6.3