Completed

Help finishing a SQL query

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([url removed, login to view],5,LEN([url removed, login to view])) (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.

Skills: Database Programming, SQL

See more: basic sql queries pdf, complex sql query examples, useful sql queries, sql queries examples, how to write sql queries, sql query examples with answers, sql query never finishes, sql queries for dummies, sql query help free lance, sql query help, write sql query joins tables example database uses, complex sql query multiple tables, write sql query parent child relation tables database, sql query tree view parent child tables, database sql query oracle help

About the Employer:
( 171 reviews ) Beavercreek, United States

Project ID: #16697388

Awarded to:

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 in 1 day
(4 Reviews)
3.2

14 freelancers are bidding on average $24 for this job

raheelhassan14

[login to view URL] to see your project.I have read the [login to view URL] to start the [login to view URL] forward . Thank You !!!

$25 USD in 1 day
(1 Review)
3.4
mpapaleo

I HAVE YOUR QUERY READY [login to view URL] I'm a SQL expert. Direct payment on p.a.y.p.a.l. I'm available right now to start the project. Please contact me on Freelancer.com chat to give me more information. I More

$20 USD in 1 day
(2 Reviews)
3.2
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 More

$30 USD in 1 day
(3 Reviews)
2.2
sfeuh

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

$15 USD in 1 day
(2 Reviews)
1.0
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 in 1 day
(1 Review)
0.6
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 in 0 days
(0 Reviews)
0.0
noorhakims

I have experience in develop software and hardware using C and java leanguage. i have been work as software developer for some company. [login to view URL] Relevant Skills and Experienc More

$30 USD in 1 day
(0 Reviews)
0.0
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 in 1 day
(0 Reviews)
0.0
yuriyes43

Hi there, After reading over your application this looks like a fit for my skill sets. I have good experiences working with sql programming. I look forward to our chat. Have a great weekend!

$35 USD in 1 day
(0 Reviews)
0.0
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 More

$25 USD in 1 day
(0 Reviews)
0.0
amflorentin

I work every day with sql data base.

$23 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0