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

80 comentarios:

Anónimo 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...

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,


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

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

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.
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...

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

Casestudysamples dijo...

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

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.

Mary Taylor 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

Cameron Boyle 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 เครดิตฟรี 50 ไม่ต้องเติมเงิน ก็รับได้ และยัง ทดลองเล่นสล็อต ฟรีทุกเกม มากกว่า 500 เกม ทางเข้า superslot รับ โบนัส ได้ทันที

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.

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.

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.

superslotgame dijo...

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

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

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

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.
mysite dijo...

That's a really great post! I'm definitely going to check out those additional SQL exercises. I'm always looking for ways to improve my skills. Thanks for sharing! venuearc give contact details

BhagyashriSevenMentor dijo...

AWS classes in pune

바카라 dijo...

마음껏 플레이하세요 바카라 실제 사람들과 함께 전 세계에서 플레이하세요.

fachai9 philippines dijo...

We have a good news! This fachai9 is opportunity to you.
There's a lot of rewards and you can enjoy all of games that we have.

online casino seo phlippines dijo...

간단한 게임을 즐기는 바카라 집에서 경험.

online esports betting dijo...

tignan ang nag aatikabong balita na meron sa aming online esports betting

blog-web-com dijo...

"Incredible Article it its truly instructive and inventive update us as often as possible with new upgrades. its was truly important. much obliged.

네임드홀짝 토토배팅 토토게임 스포츠토토야구

cyberstack seo dijo...

뜨거운 거래, 뜨거운 게임 및 더 많은 우승 기회? 이것이 바로 우리의 시도 온라인 바카라 더 보고 배우기 위해.

Sysvoot Antivirus Protection dijo...

Different cloud service providers have been challenged to being excellent power in the Cloud area as Cloud Computing has outperformed its pinnacle. Seeing every one of the accessible options is fundamental. In this article we will find out about AWS VS AZURE which cloud stage is best for organizations.

online casino seo phlippines dijo...

가장 흥미로운 온라인 수입 사이트 중 하나는 라이브 바카라 온라인 플레이. 우리는 당신이 우리 성공의 일부가 되기를 바랍니다.

ExamGrind dijo...

https://examgrinds.com/blog/page/9/

바카라 dijo...

게임을 하고 상당한 보상을 받는 데 관심이 있으십니까? 최고 바카라여기에서 재생됩니다.
게임을 하면 추가 보상을 얻을 수 있습니다. 다양한 게임을 즐기며 즐거운 시간을 보낼 수 있습니다.

온라인 바카라 플레이 dijo...

게임을 즐기고 더 즐거운 혜택을 받을 수 있습니다 온라인 바카라 플레이, 지루함을 덜 느끼는 데 도움이 될 것입니다.

Coin Master dijo...

Coinmaster is an exciting and fun game that offers hours of entertainment. It's easy to pick up and play and has a lot of levels and rewards to keep you busy. There's also a variety of events and challenges to keep you on your toes. Highly recommended for those who want a game that's easy to play yet challenging to master.
https://coinmasterfree.info/

바카라 dijo...

전 세계 수백만 명의 플레이어와 함께 최고의 무료 온라인 바카라 게임을 즐겨보세요!
바카라 세계에서 가장 오래되고 가장 인기있는 카드 게임 중 하나입니다.
지금 플레이하여 기술을 연마하고, 경험을 쌓고, 새로운 사람들을 만나고, 역대 최고의 바카라 플레이어가 되십시오!

Manoj Kumar dijo...

Great post, thanks for valuable information, also wanted to know about java or tech related information then visit: Java Classes In Pune

Outbooks UK dijo...

Best Bookkeeping Services in London. A sharp business owner understands that accurate accounting and bookkeeping are important to their ability to make reliable

hamza dijo...

Great article! It's great to see a comprehensive list of the best app development companies out there. It's also great to see the additional SQL exercises that are available to help build skills. As a programmer, I'm always looking for ways to improve my skill set and these exercises are a great way to do that. Thanks for the helpful information!

SevenMentor dijo...

Thank you for sharing the very informative article.

Software Testing Course in Pune

Seven Mentor dijo...

Very informative Blogs. Keep posting such blogs
Java Course in Pune
Java Training in Pune

Unknown dijo...

As a healthcare enthusiast, I may not be an expert in SQL exercises, but I am an expert in finding the right doctor near me. Online healthcare providers like meri sehat.pk make it easy to find a doctor who meets your specific health needs, whether you're looking for a general practitioner or a specialist. By prioritizing our health and finding the right doctor, we can take control of our healthcare journey and improve our overall wellbeing.

avajames dijo...

I am glad to see this post thanks for sharing. check this also lightinthebox discount code

BhagyashriSevenMentor dijo...

Thanks for sharing such useful information with us. I hope you will share some more info about your blog
HR course in Pune

Wilson dijo...

Thanks for your efforts to share a good information with us and I learned a lot....keep sharing more posts like this...
uncontested divorce in virginia with child
average cost of uncontested divorce in virginia

Chris dijo...

This looks like a great resource for practicing SQL. However, I'm curious to know if there are any exercises specific to computer power supplies. As technology advances, it's important to stay up-to-date on current hardware and software and having a better understanding of power supplies and their operations would be helpful in this area.

Will Steven dijo...

Seeking for a Virginia Speeding Ticket, our skilled lawyer can provide a legal advice

SevenMentor dijo...

Python's Importance in Data Science
To prepare data and do statistical analysis, data scientists use Python and R. Python offers more versatility when learning and is more widely used than R. It is also more readable and straightforward. In addition, Python offers you a wide range of applications and is utilized in many fields than data science.
Visit Data Science Course in Pune

jamesrobert dijo...

I'm sincerely grateful for the invaluable insights you've provided in this blog post. Your thorough analysis and innovative ideas have significantly enhanced my understanding of the subject. I want to wholeheartedly applaud your commitment to producing such an enlightening article. I'm eagerly looking forward to expanding my knowledge through your upcoming posts.
Abogado de Crímenes Sexuales en Nueva Jersey

Australian Assignment Help dijo...

Student Life Saviour has best experts to offer assignment assistance to students in all subjects.

Motshabi dijo...

Assignmenthelp.co.za offers best assignment help assistance to South African students at affordable prices.

Moazam Anxari dijo...

Hello, I am Anxarianworld a highly motivated and results-driven professional, with a proven track record of success; I am always seeking new challenges and opportunities to expand my skills and knowledge, and am excited to bring my expertise to your organization.For More Read Our Blog on Art of Zoo.

Assignment Help Singapore dijo...

AssignmenthelpSingapore.sg has best quality experts to offer assignment writing service in Singapore to students in Singapore at affordable prices.

Advina Jhons dijo...

A DUI lawyer in Emporia, Virginia, is well-versed in the local DUI laws and regulations. This knowledge allows them to provide you with specific legal advice and defense strategies tailored to the jurisdiction's requirements.
DUI Lawyer Emporia Virginia

ROHIT SHARMA dijo...

Software testing Course in Pune
One potential disadvantage of working in software testing is that it can be repetitive and mundane. Testing often involves running the same tests over and over again, which can be tedious and boring. Additionally, testing can sometimes be seen as a less glamorous role within the software development process, which can lead to testers feeling undervalued or unappreciated.

WebAsha Technologies dijo...
Este comentario ha sido eliminado por el autor.
Alex Dendy dijo...

Assignment help australia isn't just about grades; it's about deepening our understanding of complex concepts.

Global Assignment Expert dijo...

Looking for Reliable and trusted online assignment help? Global Assignment Help provides premium assignments to students. We are famous for our fast and accurate solutions at an affordable price. We offer a vast range of subjects like management assignment help, Computer Network Assignment Help, Programming Assignment Help, engineering assignment help, and many more. Follow three basic steps: place your order, pay, and receive an assignment. There are various features that make us No1 and a trusted assignment provider around the globe.

Mary Talyor dijo...


Acquiring the right knowledge and getting a right qualification is the key to successful career. For this proper research should be done. Most of the students find difficulty in their academic studies so they seek dissertation help london from multiple resources and get there work done.

Publicar un comentario

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