miércoles, 4 de mayo de 2011

Ejercicios adicionales de SQL

Chicos, aqui tienen una serie de ejercicios de SQL para practicar:


EJERCICIOS ADICIONALES – (aportes de Abrutsky , Rocha Vargas)



1.     Obtener el listado de articulos correspondiente al movimiento  N° 9920, indicando ademas cantidad y precio de cada uno,
2.      Incluir en el listado anterior, la información correspondiente a la descripción de los productos
3.      Comprobar que el importe total correspondiente al movimiento N° 9920, coincide con el importe neto gravado de la cuenta corriente para el mismo N° de movimiento.
  1.  Obtener un listado del nombre y apellido de aquellos vendedores que hicieron ventas por sobre el limite de credito asignado, identificando ademas que clientes se encuentran en esa situacion, ordenar la información por exceso de credito
  2. Obtener todas las ventas ordenadas por vendedor.
6.      De la consulta anterior, mostrar sólo el código de vendedor y el importe total (id_vendedor, importe_total).
7.      De la consulta anterior, agregarle el apellido del vendedor
8.      De la consulta anterior, seguir mostrando el código y nombre del vendedor, y agregar el monto total vendido.
9.      A la consulta anterior, agregarle la cantidad de ventas y ordenar por vendedor que más vendió, se sugiere utilizar nombres de columnas representativos.
10.  La última consulta mostraba la cantidad y monto total de ventas de cada vendedor, ahora se solicita discriminar por cliente. O sea, la cantidad y monto total de ventas de cada vendedor a cada cliente (sólo nombre del cliente). Ordenar por apellido del vendedor

64 comentarios:

Unknown dijo...

It is difficult to find a piece of office furniture that you like. We are a professional OEM staff workstation.Our office furniture is not only comfortable, but also of high quality and good value.

Eva E. Murphy dijo...

SQL is a very advanced database where people store their products and a lot of related services. I also created a platform for students who had Online Quiz Services. It would hold all student data, save the actual data, and notify if students attempt an online Quiz again.

The Assignment Help Nz dijo...

It's a lot of fun to read your essay. It is both instructive and useful. I seldom comment on blogs, but yours is so interesting that I can't help myself. Keep up the wonderful work; I nearly always rely on internet best assignment service, and you're doing a fantastic job.

ColinFirth dijo...

It is difficult to find a piece of office furniture that you like. Travel Guide United Kingdom They a lot of fun to comment on blogs.

thisisemliyblunt dijo...

Obtain a list of the name and surname Bathroom Wall Discount Code of those vendors who made sales over the assigned credit limit

Paul dijo...

Backlinks are links from a page on one website to another. This is important to us and you are giving us a chance and opportunity to help each other. We are hoping to have the same goal for the future of ours. https://www.chokdeebacarrat.com/ole777/

Emma Watson dijo...

Find the most recent ASOS promotion codes and voucher codes here. Purchase for less! · Get Up to half Off Men's Clothing | Foot Locker Sale · Up to 30% Off | ASOS Discount Code. asos.discount code

thisisemliyblunt dijo...

Wow, What an Excellent post. I really found this to much informative. It is what I was searching for. debenhams discount code

프로토 dijo...

스포츠토토 Excellent items from you, man. I have take into account your stuff previous to and you're just too magnificent.


프로토 dijo...

스포츠중계 Its really a great and helpful piece of information. Please stay us up to date like this. Thanks for sharing.


프로토 dijo...

토토사이트 Way cool! Some extremely valid points! I appreciate you penning this write-up

프로토 dijo...

Appreciate the recommendation. Will try it out.

바카라사이트 I am really impressed with your writing skills as well as with the layout on your weblog. keep up the excellent quality writing,


morganalbert dijo...

HealthPost Coupon Code is the best way to avail discounts on HealthPost store shopping, there are lots of items on which you can avail the discount, amazing offers so visit the store by clicking the button and Save your Pocket now!

FABLETIC LIVE WITH PASSION dijo...

Eaze Promo Code helps you save on coupon and promo codes Eaze Coupon Is the best coupon to save on, utter coupons provide updated coupons and promo codes on daily basis as Eaze Coupon to help you in saving while enjoying the best facility, you can avail this offer by clicking on the Show Code or Get deal button to use Eaze Coupon and you can also use other codes and promo codes of Eaze Coupon if one may not be working or not accepted.

FABLETIC LIVE WITH PASSION dijo...

Carters Coupon Code is best code provided by Carter's. Amazing Discount Offers, Get Carter's Coupons & Promo Codes and save up to 50% on the offer, so get the code helps you to save on coupon and promo codes. Carters Coupon Code

FABLETIC LIVE WITH PASSION dijo...

Fair weather Coupons code helps you save on coupon and promo codes.

Philips discount code helps you save on coupon and promo codes.


joeroot dijo...

Lovisa Discount code is best code provided by Lovisa . Amazing Discount Offers Get, Lovisa & Promo Codes and save up to 40% on the offer, so get the code helps you to save on coupon and promo codes.

Unknown dijo...

Cloudray Coupons code is best code provided by Cloudray . Amazing Discount Offers, Get Cloudray & Promo Codes and save up to 30% on the offer, so get the code helps you to save on coupon and promo codes.https://uttercoupons.com/front/store-profile/cloudray-coupons

morganalbert dijo...

Olay Coupons Scientists Design And Develop Skin Care Products That Work. Olay Understands How Skin Truly Behaves Through In-Depth Studies Of Skin Biology. In Their Latest Efforts, Olay Conducted The Multi-Decade And Ethnicity Project, Researching The Genealogical Science Of Skin Aging.

morganalbert dijo...

Blueland Promo Code is the best way to avail discounts on Blueland store shopping, there are lots of items on which you can avail the discount, amazing offers so visit the store by clicking the button and Save your Pocket now!

thisisemliyblunt dijo...

Acquire a rundown of the name and family name bookkeeping service near me of those sellers who made deals over the appointed credit limit

thisisemliyblunt dijo...
Este comentario ha sido eliminado por el autor.
Paul dijo...

Very nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed browsing your blog posts. In any case I will be subscribing to your feed and I hope you write again soon! www.amgames.org

joeroot dijo...

PortraitFlip Coupons code is best code provided by PortraitFlip . Amazing Discount Offers Get, PortraitFlip & Promo Codes and save up to 10% on the offer, so get the code helps you to save on coupon and promo codes.

Chris Greenwalty dijo...

SQL language is considered a difficult one from all programming languages. Last year when I was working on my computer science dissertation, I had faced lots of issues due to SQL. However, taking help from some online guides, I was able to complete it successfully.

FABLETIC LIVE WITH PASSION dijo...

Miinto Discount code is best code provided by Miinto . Amazing Discount Offers Get, Miinto & Promo Codes and save up to 15% on the offer, so get the code helps you to save on coupon and promo codes. Miinto Discount Code

FABLETIC LIVE WITH PASSION dijo...

Tower London Discount code is best code provided by Tower London. Amazing Discount Offers, Get Tower London & Promo Codes and save up to 10% Off on the offer, so get the code helps you to save on coupon and promo codes. Tower London Discount code

FABLETIC LIVE WITH PASSION dijo...

Farrar and Tanner Coupons code is best code provided by Farrar and Tanner. Amazing Discount Offers Get, Farrar and Tanner & Promo Codes and save up to 50% on the offer, so get the code helps you to save on coupon and promo codes. Farrar and Tanner Coupons code

Casestudysamples dijo...

We are the best in the business in getting you a high quality case study solution done.

morganalbert dijo...

HealthPost Coupons code is the best code provided by HealthPost . Amazing Discount Offers, Get HealthPost & Promo Codes and save up to 45% on the offer, so get the code helps you to save on coupon and promo codes.

Gregory J. Trujillo dijo...

The SQL programming language is regarded as the most demanding of all programming languages. When I was working on my Literature Review Writing Service last year, I experienced a lot of problems with SQL. I was able to accomplish it effectively with the aid of several internet tips.

derek deen dijo...

Facing Problem in Case Study Help ? Well, Instant Assignment is a place where you will get professional support from case study writing experts from skilled and knowledgeable writers at an affordable price.Our team of writers makes the best support to students

Assignment Prime Australia dijo...

A well-written assignment is very important for getting good grades in your academics. If you are facing issues in completing your Database Assignment you must visit Assignment Prime. You can hire experts that will help you with DBMS Assignment Help. For more help, you can contact +61 340521103 or you can email us at help@assignmentprime.com.

superslot dijo...

superslot free credit 50, unlimited withdrawals, the latest from the most popular game camps, the current new สล็อต, which have many great promotions, the latest today in 2022 that we can receive immediately which is easily accepted through a modern system ทดลองเล่นสล็อต We have made it easy to play for free. without having to register, do not have to share.

superslot dijo...

superslot เครดิตฟรี 50 ไม่ต้องเติมเงิน ก็รับได้ และยัง ทดลองเล่นสล็อต ฟรีทุกเกม มากกว่า 500 เกม ทางเข้า superslot รับ โบนัส ได้ทันที

superslot dijo...

superslot เครดิตฟรี ด้วยะบบ auto ที่ทันสมัย พร้อมให้บริการ ทดลองเล่นสล็อต แบบเต็มที่ แจก 10000 บาททุกเกม ทางเข้า superslot ไม่สมัครสล็อต ก็เล่นได้

slotxo dijo...

slotxo เครดิตฟรี เผยเคล็ดลับทำเงินไว ภายใน 5 นาที ทางเข้า slotxo เกมออนไลน์ แตกง่าย ทำกำไรเร็ว สล็อต เล่นง่าย ได้เงินจริง

Rylee Russo dijo...

Hello, I would like to thank you for sharing this helpful material. I appreciate that I came across this post it will help me to buy research paper outline I was actually looking.

Unknown dijo...

I really like the blog. I have shared my Nursery in Lahore with many friends and family. It is always a pleasure to read about

Lilly dijo...

finance help homework for hire. We specialize in college scholarship essay writing, research paper editing, and other academic assignments.

how to sell on shopee dijo...

Click Here business trend

keven john dijo...

Sql is a good database techniques and queries.This data base has used in many programmers.We offer an online how long should literature review be at a cheap rate.

Instantassignmenthelpaustralia dijo...

Thank you for sharing this great content !!!. Appreciable information. Do you know many students fail to acknowledge the importance of essays, writing irrelevant to the topic may lead you to get low distinctions, especially in Australian universities, the professors want high-quality researched paperwork in the assignment given? Due to lack of knowledge in writing an assignment on any topic, make students in a trouble and due to this they often seek Essay writing services from the best one. We provide and solve all problems students have and deliver 100% plagiarism-free assignments with on-time delivery of the content. With a team of expert writers and 7 years of experience in writing, the field let us allow to write the best assignment for the students.

CyberStack Solutions dijo...

Paperless business management? With Page365 you can use online invoice to management and to improve you daily transactions. Just visit Page365 PH

pg game dijo...

pg slot, the best of the online world, the hottest free slots website, unlimited deposit-withdrawal, whether it's a promotion or free credit เกมทดลองเล่นฟรี You can message us at the entrance to pg slot. We have admins to serve you 24 hours a day. Quick reply, don't let players wait for a long time. And for any player who has problems with various jams, whether it is not depositing money can't withdraw money Ask us now.

pg game dijo...

ทางเข้า pg slot เว็บตรง ใช้เคล็ดลับ ทดลองฟรี ไม่ต้องมียูสก็เล่นได้ นี้เช่นเดียวกัน เกมสล็อตออนไลน์ ที่แตกง่ายที่สุด 2022 ฉะนั้นท่านสามารถที่จะมั่นใจได้เลยว่า เว็บเรา pg slot จะมาบอกเคล็ดลับที่เราจะบอกไปนั้นสามารถใช้ได้จริงแท้แน่นอน 100%

eVisa Nation dijo...

So here is the guide for Turkey eVisa for US citizens. If you need any further information or assistance, simply reach out to eVisaNation. To get permission to visit this nation, American passport holders need to fill out the Turkey online e-Visa application form. Applicants will also be required to fulfill certain provisions to earn an authorized Turkey eVisa for US citizen.

Unknown dijo...

I've been looking for something like Dubai to Pakistan Cargo to help with a research I've been working on.

superslotgame dijo...

superslot เราจัดหนัก จัดเต็ม แจกเยอะมากกว่าทุกเว็บที่ท่านเคยรู้จัก การันตีจากยอดผู้เล่นหลักแสนท่าน เว็บเรามีบริการ ทดลองเล่นสล็อต pg มั่นคง ปลอดภัยมาเป็นอันดับที่ 1 ยืน 1 เรื่องความเร็ว ดาวน์โหลด superslot กับระบบฝากถอนออโต้ ที่รวดเร็ว เชื่อถือได้ ไม่มีขั้นต่ำ แถมยังชวนเพื่อนมาเล่นได้อีกด้วย

Cyberstack Solution dijo...

놀다 바카라 지금 온라인으로 라이브하고 놀라운 보너스를 받으세요

놀다 바카라 지금 온라인으로 라이브하고 놀라운 보너스를 받으세요

놀다 바카라 지금 온라인으로 라이브하고 놀라운 보너스를 받으세요

superslotgame dijo...

ทดลองเล่นสล็อต pg, one of the best online games to play. Every time we spin free slots, we have a chance to win. Increased free spins too. But have to look at the conditions of the superslot game to see how the chances of getting Free Spins must be played. When the chance of spinning increases The chances of jackpot winning are increasing as well. ดาวน์โหลด superslot.

Article dijo...

With fitting schooling, residents of the state transformed into responsible to the creation and improvement of its better future.
By:
She Beauty

Article dijo...

It has been seen that profoundly taught residents shape the foundation of practically any country.
By:
Articles Of The Week

Article dijo...

In this way, it's fundamental that people get the ideal schooling to make their future alongside state's long haul blasting.
By:
Articles Online

Article dijo...

Appropriate guidance assists understudies with getting more than adequate vocation open doors later on.
By:
Latest Entertainment

adad dijo...

Thanks for sharing this information. Let's talk about Medical Billing services I would like to Suggest Best Medical Billing Company. If you have not visited Greensense billing please visit for more detail.

adad dijo...

Thanks for Sharing this information If you need Revenue cycle Management Services Please visit Medical Lien Management for best services ever.

Article dijo...

Due to advantages of preparing, every understudy attempts hard to supply the best degree of direction to their own youngsters from the apparent enlightening affiliations.
By:
S4She

Article dijo...


Preparing has the important opportunity to achieve particular capacity, significantly skilled knowledge and develop our view generally around the whole world.
By:
Article Of The Week

Article dijo...

A piece of these best means to deal with the knowledge and skill of your child is get everything going grasping papers, seeing useful plans, investigating books and magazines by incredible journalists, etc.
By:
Article Online

Article dijo...

Coaching gives us higher-status and besides a predominant circumstance in basically any culture. It can help one with accomplishing the extremely needed position in an errand and qualified to frame into a fair subject matter expert, trained professional, pilot, official, teacher, etc anything that you like to change into in your own life.
By:
Latest Entertainments

CyberStack Solutions dijo...

플레이 및 이동 온라인 바카라 는 오랫동안 도박을 하는 가장 큰 장소로 알려진 최고의 선택입니다.

Touqir dijo...

computerized is presently the organization's fundamental promoting channel with most of speculation going on Web optimization
Search Engine Optimization

SEO dijo...
Este comentario ha sido eliminado por el autor.

Publicar un comentario

 
Design by Free Wordpress Themes | Bloggerized by Free Blogger Templates | Web Hosting Deals