sQL-trainer

1 Introduction. SQL database language is a basic component in the first database course. Every programmer who writes programs for database application...

56 downloads 835 Views 158KB Size
   

 



   

          !  "# $      

                                         

                                                  

                                                 !                                                                      "  !                                                                   #

   $                    %     &  '((                   %     )            "               ¯                          

     

¯            *  +,

  -   ¯            !   ¯                ¯                      

      

*            *    *      *     % .                        % /         *  % 0               % 1    *        % 2               * 



     

            

  * 

               

  *    

                       *    !       

            

                        

   3                           4        )  

                                         

    3

   

.

                  *         &                            ¯       ¯              ¯            ¯          +           ¯       !         ¯                 

&                                                      *                  )          

                  ¯         ¯          

&                       

                                        

   *                   

       ¯         ¯          ¯            ¯           +      )  

  -

*                                    "           

                               %    !                                             *              566     *  

 7. /8 *                              9                        !        +:;4 -       !                !               :;4                  *    :;4       !   :                         *               

          %         

                                                     ! 

    ¯ ¯ ¯ ¯ ¯ ¯ ¯



 



% & #'  (# ) % '  ' & #  % ' * +&  # & #' ( '' 

',  * +&  #   ! -  +&       +&  # ((#! & ' #  +&  #   ! -  +&       +& ! (   , . ' %    '  $- & '/ 0 +&   #  1    

  

*        

                                        

             "  *                     !         

* 

  &   !                    *        9  

                      

 9

%    * 

 

             !           ,  5 "                       *               "      !   *           #   :;4                *  *   3 <:; 758         *  7. /8

   

0



    &  :;4                !       !   Æ                   $                    *      *                                                     *                *           =*    =:;%*&>   

                        :;4 )                  :;4                     !         ?        =:;% &>*         *        $ 4     

          

       

¯

#, *                '  *                     

¯

 # 

¯

 $ *

¯

      @               !     

       

*                  

                             &               

                           

  

     * !      

                     !    &  

              % .    

                 !  

        : A% *         

               !       



                       !                  

     *                       4 *                   !       *               !        

       



   

       )   *   *!        *!     *            %                               *   !    *!                  !                                          !   >*!          )  *       *                       !              !       3   :;4     !         !   "     "  :;4          !      

   

 



 !          3      !          :;4          > !                            !                       

                                                                                     



       

*          5666 B        * 

                /(*0(  .*/      ?    &       /((        1((((      1          "                                  &  B(         !                       3                                                       )                *  &    !             *  &                    Æ   !   &                         !  3    *             

                                                 :;4       3                       !          *           !              !                      !



 

"      *         4         

.((5 3         *   !                *            3                           

                          !        *   4  *         ?           ?        "  !                           )                3                                        

  758 :    3     >  C & 3 * <    :  *        & 2& 3 4  & # !        '  5.2D5/( +566'-

2

   

7.8 4   &

    %  E     & 5& 3 4  & # !        '  /('D/55 +566B- 7/8 4   & $  C > *    3   + 6 -$ &  7' ' ##, 0(( ' 4'  !   /'D00 +.(((-