Make plugin using shortcode in wordpress to display database information

<?php
/**

 * Plugin Name:user info

 * Plugin URI: http://wordpress_aprai.org

 * Description: this plugin will be display data from database you can use this shortcode any where

 * Author:Arunendra Pratap rai

 */


 function display()

 {

global $wpdb;

$sql ="select * from `first_projectposts` where `post_type` = 'DisplayPost'";

$query = $wpdb->get_results($sql);

echo '';

foreach($query as $data){

$id = $data->ID;   $fname=$data->post_title;       $lname=$data->post_status;    $email=$data->post_type;  $pass=$data->post_name;

echo '';

}

echo '
id
first name
Last name
email id
Password
'.$id.'
'.$fname.'
'.$lname.'
'.$email.'
'.$pass.'
';

}

 add_shortcode( 'short_code', 'display' ); // you can use any unique name for short code
?>

USAGE :- in post or page use :-
[short_code] In template use:-
<?php echo do_shortcode('[short_code]') ?>