Examen de sql + excel

Solo disponible en BuenasTareas
  • Páginas : 2 (305 palabras )
  • Descarga(s) : 0
  • Publicado : 27 de mayo de 2011
Leer documento completo
Vista previa del texto
Name / Badge:

1. You have 2 tables:
[Table A]: Badge, Name, Manager
[Table B]: Badge, Revenue, Margin, Orders

Create the T-SQL instruction to display a table containing: Badge, Name,Manager, Revenue, Orders.

Note: make sure that all the records from [Table A] are included regardless if it is contained in [Table B].

2. You have a temporary table containing the followingfields:
Manager | Name | Revenue | Country |
Jose Perez | Dario Ortega | $600 | Panama |
Maria Sanchez | Sofia Vasquez | $250 | Mexico |
Jose Perez | Dario Ortega | $300 | Panama |
Jose Perez |Luis Gonzalez | $450 | Panama |
Maria Sanchez | Marlene Valdes | $900 | Argentina |
Jose Perez | Luis Gonzalez | $400 | Panama |
Maria Sanchez | Sofia Vasquez | $1,000 | Mexico |

Create theT-SQL instruction to display the following results:
Manager | Name | Revenue | Country |
Jose Perez | Dario Ortega | $900 | Panama |
Jose Perez | Luis Gonzalez | $850 | Panama |
Maria Sanchez |Marlene Valdes | $900 | Argentina |
Maria Sanchez | Sofia Vasquez | $1,250 | Mexico |

3. In Excel you have a spreadsheet with the following layout:
| A | B | C | D | E |
1 | Country |Headcount | Revenue | Calls | Revenue / Call |
2 | Panama | 83 | $5,000 | 100 | $50 |
3 | Colombia | 25 | $10,000 | 500 | $0 |
4 | Ecuador | 14 | $2,000 | 250 | $0 |
5 | Mexico | 46 | $5,500 | 350| |

Build a formula to calculate Revenue / Calls for the countries that have a headcount higher than or equal to 30 to fill cell E5.

4. In Excel you have a spreadsheet with the followinglayout:
| A | B | C | D | E | F |
1 | Badge | Name | | Badge | Name | Revenue |
2 | 598001 | Luis Perez | | 598004 | Hector Zamora | $12,600 |
3 | 598002 | Dario Gonzalez | | 598002 |Dario Gonzalez | $23,250 |
4 | 598003 | Roberto Arguelles | | 598006 | | $14,800 |
5 | 598004 | Hector Zamora | | | | |
6 | 598005 | Maria Diaz | | | | |
7 | 598006 | Veronica Ortiz...
tracking img