Help finishing a SQL query

$10-30 USD

완료함

게시됨

약 6년 전

$10-30 USD

제출할때 지불됩니다

I have 2 tables (attached examples) This is what I want from the _pricing table SELECT InvoiceNumber, TransactionNumber, TransDate, Confirmation, ItemPrice, ItemTax, ItemTotalCost FROM _pricing WHERE (TransDate BETWEEN '2018-04-01' AND '2018-04-02') Here is where I need help. I need the 'SalesPrice' from the _sold table. The problem is the SalesPrice is for the total items sold not individually as they are listed in the _pricing table. Also the _pricing table and the _sold table show the confirmation a little differently. in the _sold table the confirmation starts with 'CRS-' so the comparison would need to be SUBSTRING([login to view URL],5,LEN([login to view URL])) (if that's the best way??) So what I'm looking for is a SQL query that takes all the data from the _pricing table and adds a column 'sold' from the _sold table BUT the sold Total needs to be divided by the number of items, in other words I need the individual sold price.

Database Programming

SQL

프로젝트 ID: 16697388

프로젝트 정보

12 제안서

원격근무 프로젝트

활동 중 6년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@FerriSoft1

Hi, can you send a .bak with a subset of data, I can solve this for you right now, no need to be awarded. I'll show you results then you award me, expected delivery time next 1-2hours Thanks Felice

$30 USD 1일에

5.0

(10 건의 리뷰)

5.7

12 이 프로젝트에 프리랜서들의 평균 입찰은 $23 USD입니다.

@sreenivas2903

hi I am expertise in querying ping me if you need help on this , I am good mysql and ms sql server sql querying

$15 USD 1일에

4.9

(13 건의 리뷰)

4.3

@vw2107604vw

I'm a software engineer in the Pacific Northwest with a decade of experience. I can help you with your query and I will be easier to get ahold of because of my timezone. I'd like to help you with your query. Please message me about your project so we can discuss it. Thanks, Gabriel Paparella

$25 USD 1일에

5.0

(2 건의 리뷰)

2.6

@sun0815

Hello,sir. How are you? I've just read your job description very carefully and looked at your attached files. I am a SQL database expert. I have 6+ years of experience to develop various databases using SQL. For example, DBMS for booking system, train reservation system, payment system. so your job is very fit for me and my major skills. You may check my abilities and skills about SQL query. I am ready to work with you and can confirmly complete your job within 1 hour. I am very confident that you will be completely satisfied with the quality, timeliness, and professionalism of my work. Please contact me with reasonable price for this project in more detail. I am hoping to hear from you soon. Best regards.

$30 USD 1일에

4.9

(3 건의 리뷰)

2.2

@sfeuh

hi, i am available now, contact me for trying resolve the query. user the inner join methode ------------ ---------------- --------------------------- ---------------------------------------

$15 USD 1일에

5.0

(4 건의 리뷰)

1.7

@awxmem

Hello, I have 3+ years of experience working with relational database like mssql and mysql. I am confident that I can of great help to finish the query. Best regards.

$20 USD 1일에

5.0

(1 건의 리뷰)

1.0

@Denishpatel96

Hi, I can solve this within an hour or two. Give me your database or access to database so I can add column you asked for in it. Hope to hear from you. Thank you.

$25 USD 0일에

0.0

(0 건의 리뷰)

0.0

@amflorentin

I work every day with sql data base.

$23 USD 1일에

0.0

(0 건의 리뷰)

0.0

@patelrinku248

As I have just joined this site. I will give my 100% and deliver the service you want to make my profile look good. so, just fire your requirement and work will be done in no time.

$20 USD 1일에