martes, 3 de mayo de 2011

Ejercicios de SQL (copia de la guía de actividades)

Los siguientes ejercicios son una copia de los disponibles en la plataforma educativa, se incluyen solo a los efectos de facilitar el acceso a los mismos. Ante dudas en cualquier enunciado les sugiero remitirse a la fuente original.


ACTIVIDADES PRACTICAS SOBRE SQL
El caso sobre el que trabajaremos es el de una empresa distribuidora mayorista de repuestos para automóviles. Haremos de cuenta que Ud. es asistente de auditoría de un importante estudio contable nacional y ha sido asignado a un grupo de trabajo que está auditando los estados contables y el control interno de una importante firma comercial mayorista que comercializa repuestos del automotor.
La Gerencia de Sistema de la firma ha entregado un diagrama de Entidad-Relación, la definición de registros de cada una de las tablas que conforman la base de datos de la empresa y el permiso de acceso a la base de datos para realizar consultas utilizando el lenguaje SQL.
Durante el desarrollo de las tareas de auditoria se le solicita realizar una serie de consultas. Debe Ud. indicar para cada caso la instrucción SQL adecuada para resolverlo. Para comprender las sentencias de lenguaje SQL es necesario tener un conocimiento previo del diagrama de Entidad Relación y la definición de registros de cada una de las tablas que conforman la base de datos de la empresa (ver Notas de Cátedra-Unidad 5).
1. Verifique la definición de registros de las tablas: CLIENTES, INVENTARIO y CTACTE.
2. Solicite un listado con información de clientes, incluyendo los siguientes datos: nombre, cuit, domicilio, teléfono, saldo de la cuenta y limite de crédito.
3. Extraiga un listado de los clientes que superen el límite de crédito asignado. Indicar nombre, cuit, domicilio, teléfono, saldo de la cuenta y limite de crédito.
4. Verifique cuáles son los clientes que superan el límite de crédito y que no tienen su cuenta suspendida. Incluya los datos: nombre, cuit, domicilio, teléfono
5. Listado de clientes con la cuenta suspendida. Indicar Nombre, cuit, domicilio, teléfono y saldo de la cuenta.

6. Listado de artículos de stock discontinuados en los depósitos 1 y 2. Indicar descripción y stock actual.
7. Listado de las facturas que adeudan los clientes con cuentas suspendidas.
8. Listado de las facturas adeudas ordenadas por cada cliente.
9. Nombre y domicilio de los clientes que no correspondan a la provincia de Córdoba.
10. Nombre, domicilio y saldo de los clientes del sector comercial -RIO CUARTO Y ZONA DE INFL. -Si deseamos incluir también el nombre del sector comercial.
11. Listado de apellido y nombre de los vendedores cuyo código este comprendido entre 6 y 8.
12. Listado de clientes cuyo nombre comience con -Med-.
13. Listado de clientes que en su nombre figure JOSE. 
14. Listado de clientes de los vendedores 5, 6 y 7 ordenado por vendedor.
15. Listado de clientes de los vendedores 1 a 4, con residencia en la ciudad de Córdoba, ordenado por vendedor.
16. Listado de clientes de los vendedores 1 a 10, con residencia en Córdoba u otra localidad en cuyo nombre figure -RIO-. Ordenado por vendedor en forma descendente.
17. Promedio de ventas por vendedor.
18. Incluir el Nombre del Vendedor en los listados de los ejercicios 14, 15 y 16. 
19. Totales general de ventas por cliente.
20. Totales de ventas del producto -010142- por cliente. 

93 comentarios:

Burn medya dijo...

https://burnmedya.com/tiktok-takipci-satin-al/
tiktok takipçi satın al

Anónimo dijo...

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

casinositewiki 카지노사이트 dijo...

I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much Feel free to visit my website; 먹튀검증가이드

SAFE SITES18 dijo...

Appreciating the article above, really explains everything in detail. 바카라사이트닷컴

SAFE SITES18 dijo...

I found great post such as your article, its gave me lot of information. 파워볼사이트닷컴

토토사이트 사설토토 메이저사이트 안전놀이터 추천 전문가 dijo...

Private This is an online company that offers sports betting on the internet. Various betting items will be distributed to this users and the winners will be refunded according to the set dividend rate. And between Toto sites are called private Toto sites with very good capital safety toys. 토토사이트 cragro.com/블랙잭 안전놀이터

coralgrace738♡ dijo...

I wanted to thank you ffor this very good read!! I definitely enjoyed
every bit of it. I have got you book-marked to look at new thinggs you post
writing business plan services
majortotositepro1
racesiteinfo1
oncasinositeinfo1
totopickpro1

Unknown dijo...

It’s perfect time to make a few plans for the future and it is time to be happy. I’ve read this post and if I may I want to suggest you some attention-grabbing things or suggestions. Perhaps you could write next articles referring to this article. I wish to learn even more things approximately it! Feel free to visit my website; 야설

Unknown dijo...

I like what you guys are up too. Such clever work and reporting! Keep up the superb works guys I¦ve incorporated you guys to my blogroll. I think it’ll improve the value of my site Feel free to visit my website;
한국야동


Unknown dijo...

Great Post! I look forward to seeing more from you in the future. There are some very great ideas above. Feel free to visit my website;
국산야동

San Francisco Deluxe Tour dijo...

San Francisco Sightseeing Tours is the best way to see San Francisco. Their professional and experienced tour guides will show you the best of the city, and you'll learn more than you ever thought possible. The Bay Area is filled with unique and truly amazing sights, so it's important to have a knowledgeable guide show you the way. The tours are also flexible and customizable, so you can tailor the experience to your group's specific interests. San Francisco Hop On Hop Off Tours

powerballsitecom dijo...

토토사이트
I am sure this piece of writing has touched all the internet users, its really really fastidious piece
of writing on building up new weblog.

Phone Systems for Small Business dijo...

Are you looking for reliable business Phone Systems for Small Business? We offer the best business phone systems for small businesses in Las Vegas. Call today and see how you can have one of these business phone systems.

Unknown dijo...

mmorpg
İnstagram Takipçi Satın Al
Tiktok Jeton Hilesi
tiktok jeton hilesi
antalya saç ekimi
instagram takipçi
instagram takipçi satın al
METİN2 PVP SERVERLER
Instagram takipçi satın al

casinositeone.JDS dijo...


Wonderful items from you, man. I’ve have in mind your stuff previous to and you’re just extremely excellent. 카지노

casinositeone.JDS dijo...

I cant wait to read far more from you. 카지노

casinositeone.JDS dijo...

Hello there, You have performed an excellent job. I will definitely dig it and personally suggest to my friends. 호텔카지노

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.your-casino-online.com

baccaratsite.top dijo...

Definitely bookmark this and follow it everyday.
카지노사이트

totosafedb.com dijo...

I appreciate your critical thinking. Great job! 메이저사이트

slotmachine777.site dijo...

Thanks for sharing excellent information. Your web site is very cool. 카지노게임

SAFE SITES18 dijo...

Fabulous, what a weblog it is! This blog provides valuable information to us, keep it up.
바카라사이트인포

SAFE SITES18 dijo...

Information on web is always fascinating. 카지노사이트

anonymous dijo...

Aw, this was an extremely nice post. Taking a few minutes and actual effort to generate a top
notch article.
메이저토토사이트

casinosite24◾️com dijo...

Appreciate the effort and information you have given in writing this article . We offer safe and trusted online site for gamer. click here: 바카라사이트

casinositezone∞com dijo...

This is really helpful post and very informative there is no doubt about it. We recommended to you our safest Online games. go here: 카지노사이트

baccaratsite•biz dijo...

I will recommend your website to everyone. You have a very good gloss. If anyone looking for safety playground for online gaming, Feel free to visit my site: 바카라사이트

COM SPORTSTOTO-365 dijo...

That's in addition a great publish which i really valued learning. It's not every day that people maintain the opportunity to discover something. 스포츠토토

COM SPORTSTOTO-TV dijo...

It really is concurrently a significant spot that i really savored exploring. Just isn't everyday offering the outlook to see or watch something. 스포츠토토

badugisitenet dijo...

Hello, the whole thing is going sound here and ofcourse every one is sharing information, that’s truly fine, keep up writing.바둑이사이트

Corporate Gifts dijo...

Lovely post. Multi Travel Adaptor

sportstoto365 COM dijo...

Your blog is very informative. You are the real gem over the internet. Thanks for proving such a value to your visitors.

스포츠토토365
파워볼엔트리
안전놀이터

powerballsite COM dijo...

This is my first visit to this website,you have shared useful content which i like reading.I have bookmarked the website to read more similar content !
스포츠토토
파워볼
먹튀검증

superslot dijo...

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

casinositeone.JDS dijo...

Definitely a good blog is very good. Thank you for sharing. Feel free to visit my website; 카지노사이트

casinositeone.JDS dijo...

Very good written information. It will be valuable to anybody who employess it, as well as yours truly :). 카지노

Unknown dijo...

When I read an article on this topic, 카지노사이트추천 the first thought was profound and difficult, and I wondered if others could understand.. My site has a discussion board for articles and photos similar to this topic. Could you please visit me when you have time to discuss this topic?

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.

CiLlian dijo...



This seems to be the age of the entrepreneur,
슬롯사이트

Here I am once again trying to explain things to people.
슬롯사이트


Blight dijo...


We stumbled over here by a different website and thought I might check things out
검증카지노

These are genuinely wonderful ideas in about blogging.
온라인카지노

pg game dijo...

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

Hiperizle dijo...

Thank you for the information. film izle

superslotgame dijo...

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

Modafinila dijo...

Nice Post.
arcalion 200 dosage to treat chronic fatigue.

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.

Neha Verma dijo...

Really Happy with this post. Thank you so much.

Call Independent Night Chandigarh Models at affordable price..

sportstotolinkcom dijo...

I might want to thank you for the efforts you have made in composing this post. 토토사이트

okbet13 dijo...

Nice post! Thanks for sharing this quality information with us. I really enjoyed reading. check this and visit this site to know more The Advantages of Sports Betting

PillSuppliers dijo...

nice post
buy armodafinil online for treat excessive sleepiness

Modafinila dijo...

Great Post.
buy modafinil 200mg at best price.

섹시 바카라 dijo...

이것은 최고의 게임입니다. 게임을 하면서 돈을 벌 수 있습니다.
당신이 할 수 있는 모든 것은 여기에서 노는 것입니다.라이브 온라인 카지노

Juan Mark dijo...

Our software quality assurance company can help you with all your SQL needs, from basic exercises to more complex queries. Contact us today to get started!

sarifde dijo...

Great Article! Thanks for sharing
If you are looking for Abaya Collections in Pakistan, then visit vnscollection.

Flysaudi dijo...

Thanks for sharing such good blogs.
Are you planning an Umrah this year in December? FlySaudi is offering the most affordable December Umrah Packages 2022! Visit our website for more information.

Waseem dijo...

Both your writing style and the design of your blog genuinely impress me. Is this a custom theme that you created, or is it a paid theme? Anyway keep up the nice quality writing, it is rare to see a nice blog like this one today. furniture movers in Dubai

Waseem dijo...

I just wanted to say how much this blog motivated me to act! Thanks for the wonderful post. Storage Space in Dubai

PillSuppliers dijo...

nice post
bimatoprost ophthalmic solution buy online to treat eye problem

Best Vintage Speaker dijo...

Are you looking for a way to upgrade your home audio system without breaking the bank? Vintage Wharfedale Speakers offer superior sound quality and a classic look that will add a touch of class to any home. These speakers feature high-quality drivers, solid construction, and powerful sound output that will bring music to life in any room. Whether you're looking for a great way to enjoy music or just want to improve your home audio setup, Vintage Wharfedale Speakers are an excellent choice. Try them out today and experience superior sound quality like never before!
https://vintagespeakersguide.com/vintage-wharfedale-speakers-reviews/

melindas dijo...

Thanks for sharing this post. I got information on this site. Keep sharing.
new jersey divorce laws

Preslin dijo...

SQL is unavoidable nowadays. The 20 points on sql practical activities is more informative one. Thanks for your views on sql. Keep updating us more on SQL and keep sharing it. Greensville Traffic Lawyer

Anisa dijo...

There are very few people who are constantly aware of what's happening in the world of politics, television, sports, fashion, and crime. Crime news is something that gets everybody's intense attention, be it any corner of the world. Everyone requires safety, and needs assurance of everything being alright.
abogado de delitos sexuales juveniles

SpOrTsToToToP dijo...

THIS IS GREAT *-**-** BLOG FOR TODAY THAT I READ, THANKS FOR THIS!

BaCaRaSiTe dijo...

GREAT BLOG! ~~~~ I REALLY APPRECIATED IT, THANKS FOR SHARING!

slotmachinesite.com dijo...

Excellent article ! We are linking to this particularly great content on our website.

Keep up the great writing.

sportstot0tv.c0m dijo...

Hello, after reading this amazing post i am too glad to share my experience here with mates.

betmantoto.org ϟ dijo...

You’re really a good webmaster. The site loading speed is incredible.

r-toto365pro dijo...

I really like looking at and I believe this website got some really useful stuff on it!

Waseem dijo...

It will be crucial to click that website link, however this is quite helpful anyway. wordpress web design melbourne

Noah dijo...


Sex crime lawyers are criminal defense attorneys that provide representation to clients facing misdemeanor and felony charges in their particular state or country
mejor abogado inmobiliario cerca de mí

Alexandra12 dijo...

Hey there! Its so cool to read your blog.. Goodluck to you!! Keep sharing

motorcycle accident lawyer near me!

john dijo...

Thanks for the blog. very useful and interesting. would love to learn more.
volquete accidente

ˢˡᵒᵗᵐᵃᶜʰⁱⁿᵉˢⁱᵗᵉ.ᶜᵒᵐ dijo...

Asking questions are genuinely good thing if you
are not understanding something fully, however this post offers
fastidious understanding even.

betmantoto.org dijo...

This article is genuinely a nice one it helps new web users, who are wishing for blogging.

sanradavid dijo...

Great blog.. Thanks for a great process..


abogados de bancarrota de alexandria virginia

Buy Careprost Bimatoprost dijo...
Este comentario ha sido eliminado por el autor.
jamesrobert dijo...

Wow, your blog post is a masterpiece! The depth of knowledge displayed is awe-inspiring, and the way you effortlessly break down complex ideas is commendable. I particularly appreciate the practical insights you provide, making it easy for readers to implement the concepts discussed. This is undoubtedly an outstanding contribution to the field.
New Jersey Reckless Driving

zeus dijo...

slot gacor are the best online bookies and gambling agents who can certainly make it easier for you to win with the highest rtp online slot games.

harmonisjp dijo...

Gameplay that is enjoyable: Slot machines are designed to be exciting and challenging with colorful graphics, animated characters, and sound effects. A popular choice for many players, kegembiraan memutar gulungan dan menunggu hasilnya bisa mendebarkan. https://hamtronics.com/slot-gacor

netlifyjp dijo...

Slot King has a team of very helpful and friendly people. They are there to answer any questions you may have or help you if you have any problems while playing. https://raja-slot.netlify.app

topone dijo...

RTP: Rajaslot has a relatively high RTP (Return to Player), which is around 96%. This means that for every IDR 100 wagered, players can get back IDR 96 in the form of an average win. rajaslot88

spinjp dijo...

Thai slot machines are often found in casinos and other gambling establishments throughout Thailand, as well as in several other countries frequented by Thais. slot server-thailand

Tv KLX dijo...

Raja Maxwin, a site dedicated to playing jackpot slots, now offers a variety of slots to play, both low stakes and high stakes. With so many online games available slot kamboja gacor,

Self Blown dijo...

Amazing Post!!!!!!!!!!!!!
Self Blown

Robin dijo...

I’ve joined your feed and look forward to seeking more of your excellent post. Abogado Trafico Alexandria Va

Teslin dijo...

Great writing by the author. Many unknown information are provided in this blog. Keep posting more good blogs. Bankruptcy Fraud Lawyer

Birla Trimaya dijo...

Birla Trimaya was commented your article.

raelynn dijo...

Wonderful items from you, man. I’ve have in mind your stuff previous to and you’re just extremely excellentDivorcio Rápido y Fácil en Nueva York

Tv Jepang dijo...

The best Gacor slot machine site games have a very high maximum chance of winning, so it is easy for Indonesian slot players to get slot filipina maximum wins in slots. t Gacor.

Tv Melon Teh dijo...

making this site valuable for many players and members who play WinJp88 slots. Of course, the goal of all players who play is the same, namely wanting to

Tv Melon Teh dijo...

making this site valuable for many players and members who play slot gacor WinJp88 slots. Of course, the goal of all players who play is the same, namely wanting to

Tv Sulleee dijo...

making this site valuable for many players and members who play raja slot WinJp88 slots. Of course, the goal of all players who play is the same, namely wanting to

Amazing Township dijo...

Great job on this post! Your research is thorough and your arguments are compelling Provident Deansgate

Davidwilley dijo...

A good SQL exercises guide should have clear objectives and audiences, be well-organized and structured, provide clear instructions, include examples and solutions, have a gradual complexity, have a practical approach, provide documentation and comments explaining the concepts used, have a diversity of techniques, provide configuration instructions, and link to additional resources like tutorials or books for deeper learning. If you have performed exercises, share your experiences and verify that they function correctly. Verify the format and style of the content to ensure it is legible and visually appealing. Check the grammar and grammatical structure of the content to ensure it is well written and understandable. If the exercises are aimed at performance evaluation, ensure there are clear evaluation criteria. If the guide is online, encourage user interaction by starting or asking questions about the exercises. In conclusion, a good SQL exercises guide should provide effective opportunities for learners to learn and practice their skills. Your comments can help improve the quality and utility of the guide. By following these guidelines, you can create a comprehensive and effective SQL exercises guide that caters to your needs and preferences.Accidente Camión de Fedex

Publicar un comentario

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