2 simple sql Queries on the table in excel file - bid only if you can do it now for 10$
$10-30 USD
Pagado a la entrega
open the excel file you can use any sql db to work on
and do 2 Queries according to the following explanation
And the results according to the examples
The results should be saved in an Excel or CSV file
Send me the query too
1. Each ID number from column L should have only one product of each type, a product type listed in column A.
2. Each order number from column J may have only one product of each type
In column A
Find which ID numbers from column L
There is more than one type of product, and what is the order number listed in column J
And what are the products that have more than one
output samle in excel csv
L = 330810144- : J = 1167 : A = 824,823
Find out which order number from column J has more than one type of product, and what the identification number in column L is, and what are the products that have more than one.
output sample: in excel or in csv
J = 1753 : -L = 217357839 : A = 824,823
Nº del proyecto: #26922792
Sobre el proyecto
13 freelancers están ofertando un promedio de $21 por este trabajo
Hi, I'm expert in SQL and databases. I can start it right now and will complete in few hours. Let's connect. Thanks
I'm highly skilled C# programmer and Desktop developer, worked with Excel many times before and (SQL, Oracle, MS Access), please contact me to discuss details and chat.
Hi. I can do it soon. this is too easy job. please contact me, and finish this job in 1 hour. regards. Alexandra...
Hi - I have understood your request and I have downloaded the excel sheet and have the solution ready. I will like to share the solution with you if you give me the opportunity. Just wanted to add that I am a certified Más
I have experience in loading files into PostgreSQL database and extracting the results into a csv file using advanced queries if needed Relevant Skills and Experience I will be graduating from Imperial College London Más
I am an SQL expert Relevant Skills and Experience I am an expert in SQL Server and MS Excel
Hi, Having worked in finance and tech consultancies for the last 5 years I can get this done immediately. Will do for $10 right now.
Hi there! I'm a full stack software engineer, with over 5+ years experience dealing with the different programming languages, and I can help you to work on this project since previously I have been working on the same Más
Your project is ready. you can contact me and get the solution. Ready to explain in detail with examples